topic Re: How to get the mentioned value in table ? in QlikView

How to get the mentioned value in table ?

suvechha_b — Thu, 17 Dec 2015 12:04:20 GMT

Is it possible to ommit the line with yellow color.

How can I show in the table on category_of_sales='Unprocessed'.

category_of_sales is dimension.

sunny_talwar — Thu, 17 Dec 2015 12:08:09 GMT

May be use a calculated dimension:

If(category_of_sales = 'Unprocessed', category_of_sales)

and then check the 'Suppress When Value Is Null' on the dimension tab of the object properties

Anonymous — Thu, 17 Dec 2015 12:09:56 GMT

you can define a calculated dimension

if (category_of_sales<>'Processed'), category_of_sales)

or use set Analysis in Expression

{<category_of_sales-={'Processed'}>}