topic Re: Null values in pivot becuase the dimension values includes new customers every year. in App Development

Null values in pivot becuase the dimension values includes new customers every year.

meenakshi_m — Fri, 01 Jan 2021 10:25:27 GMT

hi,

Appreciate your help on below null issues .

sales made to customers is represented below when doing a pivot.

but since Raj did not exist in 2016 it shows null in pivot and while calculated movement between sales it does not show and movement.

The real data Is huge .

customers 2016 2017 2018

Meena 100 90 80

raj 100

pinky 200

Sonu 200 100 20

Re: Null values in pivot becuase the dimension values includes new customers every year.

Anil_Babu_Samineni — Fri, 01 Jan 2021 15:50:07 GMT

What do you meant by movement? Can you describe more?

Re: Null values in pivot becuase the dimension values includes new customers every year.

meenakshi_m — Fri, 01 Jan 2021 17:50:06 GMT

hi ,

movement here is calculated measure.(difference of 2 selected dates)

so in pivot have dimension of names , dates measure as sales and then i have calculated measure of difference.

however what is needed is the pivot should show zero for Raj which is null now as when i am calculating difference (movement) is just shows null.

Re: Null values in pivot becuase the dimension values includes new customers every year.

meenakshi_m — Fri, 01 Jan 2021 18:14:08 GMT

hi attaching the application file

Re: Null values in pivot becuase the dimension values includes new customers every year.

Anil_Babu_Samineni — Sat, 02 Jan 2021 20:07:31 GMT

Afaik, So far my knowledge that's not possible. But let's see If @marcus_sommer can advice workaround.

This is how Qlik Sense will work as per pivot settings..

Re: Null values in pivot becuase the dimension values includes new customers every year.

marcus_sommer — Sun, 03 Jan 2021 12:07:03 GMT

You may try to fetch the NULL with something like: alt(YourExpression), 0). Further in View exists an option to specify how NULL or MISSING values are displayed - means you could set them to '<NULL>' or 0 or anything else - I don't know if a similar option is also in Sense available.

Beside this I would remain by the native behaviour from Qlik and not adjusting the results in any way because it's simple and correct. To show 0 instead of NULL may result in confusion and wrong deductions by the users and it's quite questionable if an adjusted object/report looked really nicer.

- Marcus

Re: Null values in pivot becuase the dimension values includes new customers every year.

meenakshi_m — Tue, 05 Jan 2021 04:09:02 GMT

yes .this has worked.thanks