topic Re: Label class in pivot table in QlikView

Label class in pivot table

bartvanwetten — Mon, 13 Oct 2014 09:15:55 GMT

Dear,

In the attached file there is a pivottable with class columns. Now i have a period table (2014/11 etc..) and a corresponding number for the order. Now i can build a class for the columns. Depending on the selection (3months/4months) I have what I want. But can i rename the class labels in the columns like the period (2014/11 etc.) ??

Thx in advance!

Re: Label class in pivot table

marcus_sommer — Mon, 13 Oct 2014 11:01:03 GMT

You could use dual() to create two values - a numeric value for the calculation and the string one for the label:

dual(num(class(PeriodeOrde,3,'p',vOffset)), class(PeriodeOrde,3,'p',vOffset))

Instead the bold-expressionpart you created the period directly or used these part within a pick(match()) on a further variable or similar.

- Marcus

Re: Label class in pivot table

bartvanwetten — Mon, 13 Oct 2014 12:10:43 GMT

Marcus,

thank you very, very much, got it working!

Kind regards,

Bart

Re: Label class in pivot table

bartvanwetten — Mon, 13 Oct 2014 12:10:58 GMT

Marcus,

thank you very, very much, got it working!

Kind regards,

Bart