topic Re: restrict dimension in pivot table in QlikView

restrict dimension in pivot table

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

As per attached table ....( Pivot table)

I want to show dimension KPI K1 --> K4 in 1 table.

K5--> K7 in another pivot table and K8-----K9 in another pivot table

please suggest how to restrict pivot table like this.

tresB — Tue, 18 Oct 2016 09:34:12 GMT

Anil_Babu_Samineni — Tue, 18 Oct 2016 09:45:30 GMT

Yes, You can use like below

If(FieldName, 'K1', 'K2','K3','K4',FieldName)

sunny_talwar — Tue, 18 Oct 2016 10:01:51 GMT

I think you forgot to add the Match function Anil

Dimension for 1st table (Remember to check 'Suppress When Value Is Null' on the dimension tab for this calculated dimension)

If(Match(Kpi, 'K1', 'K2', 'K3', 'K4'), Kpi)

you can follow the same logic for the other tables.

singhcv123 — Tue, 18 Oct 2016 10:02:09 GMT

not working ......can you suggest any other mechanism to achieve the same.

lakshmikandh — Tue, 18 Oct 2016 10:08:31 GMT

If(Match(Filedname, 'K1', 'K2', 'K3', 'K4'), Filedname)

This should work, can you share expression you are using ?

vinieme12 — Tue, 18 Oct 2016 10:14:09 GMT

why not in the expression using set analysis?

KPI = {'KP1','KP2','KP'}