Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
sanjyotpatkar
Contributor III

hide/suppress dimensions based on expression values


I have created a pivot chart for roles and resource count. I would like to suppress the Roles wherever the available resource count is less than 5.

Dimension - Role

Expression for Available Resources is below -

 

count

(if(aggr(sum({<PlanType={'Allocation'}>}HCM),[Resource Name] )<=0.7, [Resource Name]))

Can anybody please help?

1 Solution

Accepted Solutions

Re: hide/suppress dimensions based on expression values

May be use the column check for all your expressions:

If([Available Resoruce] >= 5, YourExpression)

View solution in original post

4 Replies

Re: hide/suppress dimensions based on expression values

May be use the column check for all your expressions:

If([Available Resoruce] >= 5, YourExpression)

View solution in original post

sanjyotpatkar
Contributor III

Re: hide/suppress dimensions based on expression values

Do i need to add this in the conditional box above the expression box?

Re: hide/suppress dimensions based on expression values

No, this would go in the definition area. You will basically replace your expressions with new ones. Lets say you have an expression Sum(Sales). The new Expression will be:

If([Available Resoruce] >= 5, Sum(Sales))

and so on for all the expressions.

sanjyotpatkar
Contributor III

Re: hide/suppress dimensions based on expression values

Hi Sunny

Thanks. I have added the condition to every expression and suppressed the null values