Building an effective sales dashboard with Qlikview

In my last post, I talked about how a simple dashboard can provide information effectively. I'll pick up where I left off and follow the steps necessary to create the board.

En caso de que la Data SourceA "Data Source" refers to any place or medium where information can be obtained. These sources can be both primary and, such as surveys and experiments, as secondary, as databases, academic articles or statistical reports. The right choice of a data source is crucial to ensure the validity and reliability of information in research and analysis.... sea Excel (what is the case here), go to Archive -> Edit script O Ctrl + E. Once the script page opens, go to Table files.

In case you want to import data through databases, can connect via ODBC O OLE DB connectivity provided to the left of “Table files”.

Once you select the file from the desired location, the following code will be added in the script window:

LOAD City, 
     Region, 
     business_sourced, 
     rejections
FROM
C:UsersKunalDesktoptemp_qlikview.xlsx
(ooxml, embedded labels, table is Sheet1);

Once the script is written with the correct location, Save money the script and Recharge that. Once the script is reloaded, Qlikview will open a dialog box showing the list of fields that have been loaded into Qlikview. Verify that all the fields you wanted (Town, Region, business_sourced and Rejections) are mentioned in this window. Close this window after verifying the fields.

Then, right click on the main sheet and select New sheet object -> Graphic…. On the next screen, select the block chart from the chart list, add any windows title you want to add (Turnover) and click Next.

Please select Edit groups on the next screen. A window for Groups will open. In this window, select New. In the next window that opens, enter Group name (Location hierarchy), Used fields (in order of hierarchy) and the type of group (Deepen).

Click on OK a few times to exit to the Dimensions window. Add location hierarchy in Dimensions used.

When you click next, window for Edit expression it opens. This is the expression that determines the box sizes in your chart. Pay in sum (of commercial origin) here.

Once you press OK, The window for expressions opens, with the definition provided in the last window. Add the desired tag (trade volume) y expanda los parametersThe "parameters" are variables or criteria that are used to define, measure or evaluate a phenomenon or system. In various fields such as statistics, Computer Science and Scientific Research, Parameters are critical to establishing norms and standards that guide data analysis and interpretation. Their proper selection and handling are crucial to obtain accurate and relevant results in any study or project.... (as in the following screen).

Then, can select Background color and click Definition. In this window, you can define the parameter to define the colors of the boxes in your chart. Insert the following code in the expression tab:

if(sum(rejections)/sum(business_sourced) < 0.06, green(), red())

This expression would color the box red when there are rejections higher than 6%, otherwise they will be colored green.

If you want to add green and red gradients, the code can be changed to something like this:

if(sum(rejections)/sum(business_sourced) < 0.06, 
colormix1(sum(rejections)/sum(business_sourced)*10,green(), lightgreen()),

colormix1(sum(rejections)/sum(business_sourced)*5,lightred(), red())) 

This expression would color the gradient squares between green and light green or red and light red. Then, you can click End up to see your graph.

Este sencillo tutorial crea un panelA panel is a group of experts that meets to discuss and analyze a specific topic. These forums are common at conferences, seminars and public debates, where participants share their knowledge and perspectives. Panels can address a variety of areas, from science to politics, and its objective is to encourage the exchange of ideas and critical reflection among the attendees.... eficaz con detalles y colores que muestran la calidad del negocio. I hope the tutorial has been useful to you.

If you have any question, dont Duce to talk with me. What's more, let me know in case you apply these ideas elsewhere.

If you like what you have just read and want to continue learning about analytics, subscribe to our emails or like ours page the Facebook

Related