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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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