topic hide/suppress dimensions based on expression values in QlikView

hide/suppress dimensions based on expression values

Anonymous — Thu, 21 Jan 2016 10:08:35 GMT

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?

Re: hide/suppress dimensions based on expression values

sunny_talwar — Thu, 21 Jan 2016 10:11:38 GMT

May be use the column check for all your expressions:

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

Re: hide/suppress dimensions based on expression values

Anonymous — Thu, 21 Jan 2016 10:20:21 GMT

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

Re: hide/suppress dimensions based on expression values

sunny_talwar — Thu, 21 Jan 2016 10:23:16 GMT

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.

Re: hide/suppress dimensions based on expression values

Anonymous — Thu, 21 Jan 2016 10:29:21 GMT

Hi Sunny

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