solution

[#1]

i have data like attached in excel,i have to show in qlikview chart below listed  types four as it is and other than that as other  sum of sales for each month

abc

cam

dec

yre

Others

also i want to show % changes for each type for months wise sales,visit etc .

can i make a chart which show sum of visits for each month selected by seletion list as well as one month previous sum of visit in one single chart.

[#2 · Accepted solution]

Hi,

Try use this script when you load your data:

LOAD type,

     visit,

     sales,

     download,

     month,

     if((type='abc'),'abc', if((type='cam'),'cam', if((type='dec'),'dec', if((type='yre'),'yre','Others')))) as typegroup

FROM

filepath:data.xlsx

(ooxml, embedded labels, table is Sheet1);

Then you can using typegroup as a dimension in your chart.

Regards

[#3]

Hi,

Attached is an example about how to do it with variables and dimension and expression.

However, be aware that this way may have an negative impact on performance.

Regards,

http://quickdevtips.blogspot.com/

[#4]

but what about % change,i want to show change for all types for all month means value for any type for month jan

,minus value for same type for mon th feb i.e user select month i want to show differance of selected month value to

previous month value.is there any way to calculate this.