Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
Please could you help me to represent in a pie chart the share of null value and non-null value (in %) from a specific field.
Thank you in advance for your help.
Create a flag in the back end like
if(Isnull(YOurDimension),0,1) as flag
Use the flag as a dimension in the pie chart.
I hope this helps!
Regards,
Arpit
Hi @arpitkharkia ,
Thank you for your help.
Please could you explain when you say "create a flag in the back end"?
Is it in the script editor or in expression part of the graph ?
Thank you in advance for your help.
This is in the script, it would not put load on the front end graph, and it will load faster.
I hope this makes sense! 🙂
I think that I don't take it in the good way. Indeed, when I try it, I have an error message.
Below my code in the script editor:
LOAD
IF (Isnull(name),0,1) as flag
FROM customer_table;
Please could you tell me what is false in the code above.
Sorry, for my low level in Qliview...
Thank you in advance for your help.
What is the error? If you can share some sample data it will be great!