Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amijit_hazarika
Contributor III
Contributor III

Showing values of 2 dimensions on basis of a 3rd dimension

Hi Qlik Experts,

I have 3 dimensions A,B and C.

I have created a table in QLik Sense.

Suppose A has values like 1,2,3,4 etc

I want to show values for 1 only in dimensions B and C. Since I want to show values only for 1 from dimension A, I would like to hide the dimension A.

May I know how this can be met?

I am using;    =A = '1' but it ain't working.

Thanks

3 Replies
sunny_talwar

May be use set analysis in your expression

Sum({<A = {'1'}>}Measure)

amijit_hazarika
Contributor III
Contributor III
Author

Hi Sunny,

Thanks. But I am using a straight table in Qlik Sense.

I am having only dimensions and no measures.

sunny_talwar

May be use an if statement

If(A = 1, Dimension1)

If(A = 1, Dimension2)

... and so on