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

[amijit_hazarika]

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

[sunny_talwar]

May be use set analysis in your expression

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

[amijit_hazarika]

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