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

changing column in to row in straight table

qvw.png
Hi,

In the above image MAR-2014 is showing in seperate column i need to be included in the column like the months of apr, may, jun.

so i need to convert the column in to the second column as a row

6 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

Can you post your sample application.

Regards

ASHFAQ

tresesco
MVP
MVP

Take a pivot table and pull the month dimension across to  column.

Not applicable
Author

the actual thing is that in sample application if i click the financial year 2014 i need to get from march-2013 to march-2014 means total 13 months of data as comparison to the closing stock of last financial year ..

my financial year starts from april to march..

in the above straight table i need to get the month of march -2014 to be included in it

Not applicable
Author

by pulling column it promote or demote the particular column but is not moving above the apr-2015

Not applicable
Author

Please check the sample attached..

Not applicable
Author

Hi bro,

What did u do plz check my sample app and the image i know to create a chart and change rows in to column but in my image it i need to interchange the place of my expression into the place of dimension and the other option is i have used one calculated dimension as 'month-&financialyear' in one dimension and the other thing that i need to add is this calculated dimension to get the desired result

 

Month(vMinDate)&'-'&(vPrev_FinYear)