Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

conditional sorting of the rows of a dimension which has been transposed to make the columns in a pivot table

Hi

I have developed a report in which i have used a  calculated dimension to make columns for the expression by transposing it,

year_cd & '-' & month_cd, this calculated dimension has been created. its value is like this py-jan,py-feb...

.....py-dec.

Now the data is refreshed after every month, and the reports are based on the data of the 12 months.

i need to show this dimension in a pattern which changes every month, its like

for jan, it must start with py-jan,py-feb......

for feb,it must start with py-feb,py-mar........py-jan.

and so on till december.

How can i achieve that????

0 Replies