Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

bartvanwetten
Contributor

Label class in pivot table

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!

Tags (3)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Label class in pivot table

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

View solution in original post

3 Replies
MVP & Luminary
MVP & Luminary

Re: Label class in pivot table

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

View solution in original post

bartvanwetten
Contributor

Re: Label class in pivot table

Marcus,

thank you very, very much, got it working!

Kind regards,

Bart

bartvanwetten
Contributor

Re: Label class in pivot table

Marcus,

thank you very, very much, got it working!

Kind regards,

Bart