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

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

SatyaPaleti — Sat, 16 Nov 2024 18:27:56 GMT

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

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

fosuzuki — Sat, 20 Jun 2020 16:20:50 GMT

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.

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

SatyaPaleti — Mon, 22 Jun 2020 02:49:52 GMT

Hi Fosuzuki,

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

Thanks and Regards,

Satya