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: 
trdandamudi
Master II
Master II

Year and Quarters in a pivot table

I have Year and Quarter data in a table along with amount. (See the attached .qvw file). I want to show the year and quarter as shown in the output. Any idea ?

Thanks

This is what I have in a pivot table:

YearAndQuarter_01.jpg

But the output should be as below:

YearAndQuarter.jpg

1 Solution

Accepted Solutions
sunny_talwar

Combining them into one should not be a problem

Capture.PNG

Feeling lazy to do the second part. Can you take this forward?

View solution in original post

6 Replies
sunny_talwar

What don't you try using the Pick(Dim(...)) approach? Have you already tried it?

trdandamudi
Master II
Master II
Author

Thought of it but then I have two separate dimensions and felt it is not possible... Any samples..?

Thanks

sunny_talwar

Combining them into one should not be a problem

Capture.PNG

Feeling lazy to do the second part. Can you take this forward?

sunny_talwar

Here you go

Capture.PNG

trdandamudi
Master II
Master II
Author

This is exactly what I was doing and I saw your response.. I will take this to the next step and see..

Thanks

kkkumar82
Specialist III
Specialist III

Hi Sunny,

Can you elaborate how this Dim worked after the last value of the dimension

Kiran Kumar