Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Only show dimension if value equal to another dimension

Hi community,

In a pivot table I have two dimension

Dimension1Dimension2
1030631961
10306310361
103063103063
103063103063

I only want to make sure that the values from Dimension 2 show when thay are equal to Dimension 1. And not see the other records at all.

I have searched the forum but can't find a solution.

I have tried this calculated dimension since it seems logical but it aint working:

=only({$<Dimension2 = {'Dimension1'}>} Dimension2)

Thanks for the help!

1 Solution

Accepted Solutions
Highlighted

Re: Only show dimension if value equal to another dimension

Try this:

if(dimension1 = dimension2, dimension1, null())

in the dimension and check box "exclude null value"

Obviously there will be only 1 dimension

Hope it helps

View solution in original post

1 Reply
Highlighted

Re: Only show dimension if value equal to another dimension

Try this:

if(dimension1 = dimension2, dimension1, null())

in the dimension and check box "exclude null value"

Obviously there will be only 1 dimension

Hope it helps

View solution in original post