topic Re: Variable in Pivot Chart in QlikView

Variable in Pivot Chart

Fri, 08 Jan 2016 04:34:03 GMT

Hi everyone,

I am in trouble with variable. I create "vPriorYear" variable and put it into Expression of Pivot Chart on the following statement:

Num((Sum(NetSalePerDate)-Sum({<Year={$(vPriorYear)}>} NetSalePerDate))/Sum({<Year={$(vPriorYear)}>} NetSalePerDate)*100,'#.#')&'%'

But it is not work. However, it's work in the Text object . I really misunderstand that why this wrong measure in Pivot Chart ?

Anybody can please help me, please? I will attached my qvw file as below

Re: Variable in Pivot Chart

Gysbert_Wassenaar — Fri, 08 Jan 2016 17:19:57 GMT

You're using Year as a dimension in your pivot table. Because of that your pivot table is limited to values from 2016. There are no values in 2016 where the year value is 2015 so you don't get any result with the set modifier Year={$(vPriorYear). If you remove the Year dimension from the pivot table you'll get results as long as you don't choose Date as Time Option. Then you're stuck with values from only 2016 again.

Re: Variable in Pivot Chart

Mon, 11 Jan 2016 02:49:58 GMT

Thank you for your reply, gwassenaar‌. But I want to use Year Dimension in this table, Can you give me another solution for this, please?

Re: Variable in Pivot Chart

Gysbert_Wassenaar — Mon, 11 Jan 2016 16:38:49 GMT

The As-Of Table