Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Hide Columns based on Conditions

Hi Team,

 

I have a particular question based on my dataset requirement.

I am using Pivot Table and I have Summary field in Dimension and Month field  in Column and I have 3 measures - Actual, Budget and Forecast.

The output I want is from "Jan to Aug" Month the measure shown in the pivot table should be actual and Budget but from Sep month which is the current month and onward  I want to see all 3 measures Actual, Budget and Forecast.

I am using show if column condition in the Forecast measure, but its not working properly. Either its showing forecast for each month or not showing it at all.

I want to see all months together but from Jan to Aug i want see only actual and budget and then from Sep to Dec I want to see Actual , Budget and Forecast.

Thanks in advance 🙂


I have uploaded the example, How the output should look like.

 

1 Reply
Highlighted

Re: Hide Columns based on Conditions

Hiding of expression based on the dimension values is not possible .

Alternatives :

1. Keep 3 expression in all the months for the selected months code it as NA or 0 

2. Build 2 different charts i.e. from month Jan to Aug and then Sep to rest and place it side by side 

 

I would advise to go with option 1 , because option 1 is easy to maintain