How to convert dimension as measure in a qlik sense table to disable filtering functionality

[Bhushan1]

Hi All,

I have a requirement in qlik sense. I am using qlik sense table with one dimension called Country and three measures called M1, M2 and M3

Country	M1	M2	M3
IN	10	30	50
US	20	40	60
UK	30	50	70

when user click on IN ,then country automatically filter out for Country= IN. but our requirement is even when user click IN or US or UK from table, it should not filer out the data.

as we know this is a qlik sense feature , we don't have option to disable. so I am thing to convert country as a measure which will show 3 rows and measure will not show the filter option.

so kindly let us know how to create measure on country dimension.

Regards,

Bhushan

[Anil_Babu_Samineni · Accepted solution]

Check, If this is what you are expecting? I have the work around, If I understand correctly..

[Bhushan1]

Hi Anil,

Thanks for your quick reply. I will look into this workaround and get back to you.

Regards,

Bhushan

[anushree1]

Please  Check if this works