Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

cbaqirdhds
Contributor II

Combining Dimension Values

I want to accomplish 2 things:

1.if the Description is the same in both the ECISA and CAREB Domain, Make the List Box for the Domain filter show an option for A/B

2. Show the A/B value in the Table if count(DESCRIPTION)=2 and therefore only 1 row

I was trying to use =if(count(DESCRIPTION)=2,'A/B',DOMAIN)

It works in the text box, but it doesn't work in the table or the list box.

7-19-2017 7-47-14 AM.jpg

Tags (2)
1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: Combining Dimension Values

Check this?

5 Replies
vishsaggi
Esteemed Contributor III

Re: Combining Dimension Values

Can you share your qvw which has that Power Plan Review Audit table and A/B listbox? The one you shared has nothing in sheet6.

cbaqirdhds
Contributor II

Re: Combining Dimension Values

Whoops - I had that sheet hidden. I will update.

cbaqirdhds
Contributor II

Re: Combining Dimension Values

updated

vishsaggi
Esteemed Contributor III

Re: Combining Dimension Values

Check this?

cbaqirdhds
Contributor II

Re: Combining Dimension Values

thank you!

Community Browser