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: 
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Pivot Table Month Column Expansion Not Working When Using Calculated Dimension

Hi all,

I have a problem with pivot table when expanding the month columns, it does not work.

This occurs when i attempt to apply a calculated dimension(toggle between Month and Quarter). 

The example below is what I would want to achieve:

Month selected is Jun, but Month for May and Apr is still expandable.

Normal Month.PNG

This works on normal Month Dimension, when i apply the calculated dimension, the problem occurs where:

Month selected is Jun, May and Apr could not be expanded.

monthToggle.PNG

Any idea on how to achieve the expected result?

Attached is a sample qvw with the table on 'Month\Quarter' sheet.

 

Thanks and regards,

Arthur Fong

 

 

 

 

 

 

Labels (1)
11 Replies
uacg0009
Partner - Specialist
Partner - Specialist

Hi,

I saw your qvw, I think the problem is not the calculated dimension,

because you use {<Month=>} set analysis in expression,

so when you choose Q2 and Jun, the pivot table shows May, Jun and Jul.

If you delete the set analysis, it will be fine, please try.

Aiolos Zhao

Arthur_Fong
Partner - Specialist III
Partner - Specialist III
Author

if i remove set analysis, i would get only Jun.
Thanks.
adamgaox
Creator
Creator

Hi JKfong,

I would suggest you to declare the requirements you want.

Best Regards.

Jiawen.

adamgaox
Creator
Creator

Hi Jkfong,

If you want to know your Jun sales value, just collapse the button on Jun why u need to select Jun in the selection?

 

Arthur_Fong
Partner - Specialist III
Partner - Specialist III
Author

Hi Adam,

In the dashboard, when user click on Quarter, they are able to see Q1-Q4, YTD Actual, and PY Actual.

 

For YTD Actual, user shall select on Month to look at the YTD figure.

Eg: When user select Jun, he should see Jan-Jun figure(cumulative sum) on the YTD column.

That is the reason why Month have to be selected as well.

Thanks.

 

 

 

uacg0009
Partner - Specialist
Partner - Specialist

Hi,

Sorry, just now I misunderstood what you want.

How about if you check the "Always Fully Expanded" in Presentation tab.

Aiolos Zhao

Arthur_Fong
Partner - Specialist III
Partner - Specialist III
Author

Hi Zhao,
This option will not allow the user to collapse when they want to.
Thanks.
adamgaox
Creator
Creator

Hi Jkfong,

I understand when u select month it will change the YTD calcuated period but how it matters the collapse and expand functions in the pivot table.

From my point of view they're exactly different requirements.

 

Arthur_Fong
Partner - Specialist III
Partner - Specialist III
Author

Hi Adam,
They are different requirements but how to put these requirements together?
Below is the flow of the scenario:
Eg: 1. User selects Juneto see Jan to June YTD figure.
2. They saw a big figure on May and would want to expand and see where the figure comes
from.
3. They could not expand May as shown in the screenshot above.

Thanks.