topic Display Null Values in QlikView

Display Null Values

Anonymous — Thu, 06 Nov 2014 14:28:20 GMT

I have Straight Table with 5 Dimensions and 1 Expressions.

In Expression i have 7 rows which are having values and rest of them are null values and i have to display only NULL values.

For example column name is sum(sales) Rows don't have sales appearing as "-" in table and rest of them have values.

I need to know how we can display only NULL values.

All dimension Suppress Null values are Uncheck.

Thanks

Manish Madan

Re: Display Null Values

Gysbert_Wassenaar — Thu, 06 Nov 2014 14:38:31 GMT

Maybe like this: Sum({$-<sales={'*'}>}sales). If not, then it would help if you can post an example document that demonstrates the problem.

Re: Display Null Values

kji — Thu, 06 Nov 2014 14:41:23 GMT

On the dimensions tab, make sure to check "Show All Values"

Re: Display Null Values

Anonymous — Thu, 06 Nov 2014 15:56:21 GMT

Hi ,

I Can't share the App.

I have a scenario where i have some set of employees and each employee is mapped with 5 KPI's and each KPI is having a status codes like 0,'',1,2,3.

[EMP->KPI->CODE]

Now i have to separate out these Employees in two bucket like Employees having KPI status code in 1,2,3 then it should fall in one table and KPI with code 0 and '' in another table.

Bucket 0 and '' must have only those Employee whose all KPI mapped should be either '0' or '' .

please let me if any example required.

Suggest.

Thanks

Manish Madan