Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
What do you meant by movement? Can you describe more?
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.
hi attaching the application file
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..
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
yes .this has worked.thanks