topic Re: How To Provide Specific Expression on for specific Dimension Value in QlikView

How To Provide Specific Expression on for specific Dimension Value

SatyaPaleti — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

Here there is a requirement I need it

I have 2 dimensions 1. Month and 2. Categories and I have 2 Expressions 1. Sales an 2. Target

Here I have Create Pivot Table . In the below Pivot Table we have metrics like Sales, Target & Percentage (%). But Percentage should get appear only for Dimension Value Others. Can some one please help how to make % should appear only for Others. For more etail please find attached files for excel an QVW

Thanks an Regards,

Satya

Re: How To Provide Specific Expression on for specific Dimension Value

giovanneb — Mon, 03 Sep 2018 14:23:15 GMT

Hi, Try this

sum({$<Categories = {'OTHERS'} >} Target)/sum({$<Categories = {'OTHERS'} >} Sales)

Re: How To Provide Specific Expression on for specific Dimension Value

SatyaPaleti — Mon, 03 Sep 2018 15:44:18 GMT

Thanks for quick responce But below pivot chart is coming