How to hide a specific Measure based Selections made on Alternative dimensions in Qliksense

[SatyaPaleti]

Hi Experts,

Need your help on the following requirement.

I have 2 Measures 

1. Sales

2. Estimated Sales

I have 2 Alternate Dimensions

1. Product

2. Month

and I am using these 2 Measures and these 2 alternate dimensions (Product & Month)

so when i select Month as a dimension then it have to show 2 Measures both  (Sales, Estimated Sales) and when i select Product as a dimension then it have to show only one Measure (Sales)

Here is the screenshot

When Month is Dimension it have to show 2 Measures both Sales & Estimated

When Product is Dimension it have to show only one Measures both Sales 

Could some one help me how can we resolve this issue.  is this functionality is possible in Qliksense?.

For sample application you can find attached document 

Thanks and Regards,

Satya 

[fosuzuki · Accepted solution]

The Combo Chart doesn't have an option to conditional show a measure.

If you put the Estimate Sales expression like this:

if(GetObjectDimension(0)='Month',Sum(EstimatedSales))

the expression will return null when Product is selected. Visually the line will not show, but the legend will still be there.

[SatyaPaleti]

Hi Fosuzuki,

Thank you so much it's working as expected. Thank you so much for your responce

Thanks and Regards,

Satya