Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor

Showing dimension in table conditionally

I want to display  [Commissions.CUSTOMER] if the distinct number of Commissions.INC_COMM_LEDGER is greater than one in the past month (Commissions.TRADE_MONTH_START)

I used this

=IF(COUNT({$<[Commissions.TRADE_MONTH_START]={'$(=Monthstart(Date(today(),'M/D/YYYY')))'}>} Distinct [Commissions.INC_COMM_LEDGER]) > 1,[Commissions.CUSTOMER])

If I put this condition as a measure and show True or False, like shown below, it works, but when filtering out the dimension it says invalid dimension.

=IF(COUNT({$<[Commissions.TRADE_MONTH_START]={'$(=Monthstart(Date(today(),'M/D/YYYY')))'}>} Distinct [Commissions.INC_COMM_LEDGER]) > 1,"True", "False")

How can I do only show the dimension CUSTOMER when this condition is true in my table?

Many thanks

1 Solution

Accepted Solutions
Highlighted
Valued Contributor II

Re: Showing dimension in table conditionally

You need to add [Commissions.CUSTOMER] as a normal dimension

then, under "show column if" just write this:

=COUNT({$<[Commissions.TRADE_MONTH_START]={'$(=Monthstart(Date(today(),'M/D/YYYY')))'}>} Distinct [Commissions.INC_COMM_LEDGER]) > 1

View solution in original post

1 Reply
Highlighted
Valued Contributor II

Re: Showing dimension in table conditionally

You need to add [Commissions.CUSTOMER] as a normal dimension

then, under "show column if" just write this:

=COUNT({$<[Commissions.TRADE_MONTH_START]={'$(=Monthstart(Date(today(),'M/D/YYYY')))'}>} Distinct [Commissions.INC_COMM_LEDGER]) > 1

View solution in original post