Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
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