topic Re: Question about Pivot table in QlikView

Question about Pivot table

francisvandergr — Wed, 13 Feb 2013 20:03:04 GMT

Ha,

I have a pivot table which works as follow when i select in the table asofmonth a period i see in my pivot table the last 24 months in the order i want.

What i extra want in this table is in column1 the following: when i for example choose "Aug 2010" i wanna see in colum1 the total sales from "jan 2010 till till aug 2010"

Is this possible in this pivot table

Re: Question about Pivot table

Gysbert_Wassenaar — Wed, 13 Feb 2013 20:41:47 GMT

Try this as calculated dimension: =aggr(sum(if(MonthYear>=YearStart(AsOfMonth),Sales)),AsOfMonth)

Re: Question about Pivot table

francisvandergr — Wed, 13 Feb 2013 23:02:43 GMT

Thnx for sofar ! Is this also possible with set analysis? I understand that i can better work with set analyse in qlikview as with if statements for a better performance

Re: Question about Pivot table

Anonymous — Sat, 16 Feb 2013 17:58:30 GMT

Hi,

i think it is possible in pivot table,

but you need to wrote a two expression for single mesures

EX:

if(getfiledselectedcount(myfieldname)=0,then your 24 months expression,

you current ytd expression)

EX1:

you can handle in varibles also

write a variable based on selection,

create a two variable for VarMIndate and VarMaxDate

any month or year selection hapeen take Min and Max date varibale for current ytd other wise 24 months Min and Max date variable in expression.

Regards