topic Re: Qlik Sense, plot total average and distinct values at the same time in App Development

Qlik Sense, plot total average and distinct values at the same time

Federico_Rizzello — Thu, 10 May 2018 10:43:01 GMT

Hi Community,

I'm trying to plot in line, bar or combo chart my data with:

2 dimensions
- Date, expressed in Year Month
- Store, expressed as a string that show the store's name
1 measure: sum of sales (in quantity)

I would like to plot on the same chart the average of sales by date of all the stores (or the average of the selected stores), at the same time with my distinct stores.

My target is to create a visualization that lets my user to visualize the difference between the total average and the single stores.

Here is a snapshot of my line chart.

Thanks in advance for any suggestion and precious help. Best regards.

- Federico Rizzello

Re: Qlik Sense, plot total average and distinct values at the same time

dwforest — Thu, 10 May 2018 15:57:28 GMT

Default chart visualization can have multiple dimension OR multiple measures.

Re: Qlik Sense, plot total average and distinct values at the same time

Federico_Rizzello — Fri, 11 May 2018 09:49:24 GMT

Thanks for your reply.

I get your suggestion, but I don't know how to add a second measure (e.g. the overall average) while I already have two dimensions (Dates, Stores) on my chart.

Re: Qlik Sense, plot total average and distinct values at the same time

Anonymous — Mon, 14 May 2018 11:47:49 GMT

Hello Federico,

this is not a nice solution but I think it can work for your case.

Create a fake dimension called for example "Cod_Negozio_New" in the following way:

LOAD DISTINCT Cod_Negozio, Cod_Negozio AS Cod_Negozio_New resident "your transaction table"

Concatenate

LOAD DISTINCT Cod_Negozio, 'Average' AS Cod_Negozio_New resident "your transaction table"

In this way your new store dimension will contain a new value 'Average' associated with all your original stores.

Then in graph use "Cod_Negozio_New" instead of "Cod_Negozio" and in the expression write something like this: IF(Cod_Negozio_New = 'Average', AVG(Sales), SUM(Sales)).

Hope this helps.

Regards