Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

amijit_hazarika
New 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

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

May be use set analysis in your expression

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

amijit_hazarika
New Contributor III

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

Hi Sunny,

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

I am having only dimensions and no measures.

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

May be use an if statement

If(A = 1, Dimension1)

If(A = 1, Dimension2)

... and so on

Community Browser