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

[meenakshi_m]

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  

[Anil_Babu_Samineni]

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

[meenakshi_m]

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.

[meenakshi_m]

hi attaching the application file

[Anil_Babu_Samineni]

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..

[marcus_sommer · Accepted solution]

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

[meenakshi_m]

yes .this has worked.thanks