topic Re: How many ways finding missing values in QlikView

How many ways finding missing values

Anonymous — Sat, 04 Aug 2018 04:20:18 GMT

hi all

petter — Sat, 04 Aug 2018 06:24:00 GMT

Anonymous — Sat, 04 Aug 2018 06:58:21 GMT

examples

BalaBhaskar_Qlik — Sat, 04 Aug 2018 07:06:55 GMT

Like below, there are many ways to identify missing values and fill those values.

Pivot table - Presentation, you can select the sign to show when is Null.

like if(sum(sales) = '-','!','V')

like if(isnull(field1),Peek(field1),field1) as field2 resident TransactionTable

Using Master calendar

Using Previous(), Peek()

Using variables.

AutoNumber()