topic solution in QlikView

solution

Thu, 07 Jun 2012 18:54:09 GMT

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.

solution

Thu, 07 Jun 2012 20:57:25 GMT

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

Re: solution

Thu, 07 Jun 2012 21:58:43 GMT

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/

solution

Fri, 08 Jun 2012 05:11:11 GMT

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.