Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bartvanwetten
Creator
Creator

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!

1 Solution

Accepted Solutions
marcus_sommer

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
marcus_sommer

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

bartvanwetten
Creator
Creator
Author

Marcus,

thank you very, very much, got it working!

Kind regards,

Bart

bartvanwetten
Creator
Creator
Author

Marcus,

thank you very, very much, got it working!

Kind regards,

Bart