topic Re: Grouping dimension values in QlikView

Grouping dimension values

venkatasuresh — Sat, 16 Nov 2024 18:37:10 GMT

Hi Guys,

Need your help on below query.

One of my pivot table i have used dimension called 'Distributor'

under Distributor i want to display Others and null values '_' together

EX:

Distributor	Quantity	sales
Amazon	14	4000
flipkart	12	2000
ebay	8	3000
sanapdeal	6	1200
Others	18	3400
-	27	6000

Expected output:

Distributor	Quantity	sales
Amazon	14	4000
flipkart	12	2000
ebay	8	3000
sanapdeal	6	1200
Others	45	9400

i have added the calculation dimension like below

=if(Match([Distributor],'Amazon','flipkart','ebay','sanapdeal','Others'),[Distributor],'Others')

but its not given expected out put

Thanks,

Suresh V.V

Re: Grouping dimension values

Or — Tue, 19 May 2020 13:34:27 GMT

I would recommend doing this in the script, by setting up a new field, Distributor_Without_Nulls, which would have the formula:

if(isnull(Distributor),'Others',Distributor) as Distributor_Without_Nulls

If you don't want to do this script-side, you could also use this code in a calculated dimension, but in this case, users would not be able to click "Others" and get the correct selections applied, I think.

Re: Grouping dimension values

Saravanan_Desingh — Wed, 20 May 2020 01:12:53 GMT

One solution is.

=If(IsNull(Distributor) Or Distributor='Others', 'Others', Distributor)

Script:

tab1: LOAD If(Distributor='',Null(),Distributor) As Distributor, Quantity, sales INLINE [ Distributor, Quantity, sales Amazon, 14, 4000 flipkart, 12, 2000 ebay, 8, 3000 sanapdeal, 6, 1200 Others, 18, 3400 , 27, 6000 ];

Re: Grouping dimension values

venkatasuresh — Wed, 20 May 2020 05:53:16 GMT

Hi Thank you so much for your kind support:)

I fixed this issue by using apply-map function

I tried both of your solutions its working fine on my local desktop,once i publish the application on access point

i can see the null value '_' , the i tried apply map the issue got fixed.

Thanks,

Suresh V.V