Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
singhcv123
Contributor
Contributor

restrict dimension in pivot table

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.

6 Replies
tresesco
MVP
MVP

Anil_Babu_Samineni

Yes, You can use like below

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

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
Contributor
Contributor
Author

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

lakshmikandh
Specialist II
Specialist II

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

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

vinieme12
Champion III
Champion III

why not in the expression using set analysis?

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.