Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display in Barchart

Hi All,

I have a bar chart for which Month as the Dimension, for that the Expression is having Numerator and Denominator. in some cases the denominator can be 'Null' or '0'. so in this cases i need to display 'NA' for that particular month. Is it possible to do the same.

Thanks in Advance

16 Replies
MK_QSL
MVP
MVP

USE BELOW IN Expression

ALT(yourexpression, 0)

or

ALT(yourexpression, 'NA')

Not applicable
Author

Hi,

I have tried that, if it is '0' then it is displaying 0 for that month, but when giving 'NA' it is not displaying anything.

Thanks

its_anandrjs

Try like this

If(Isnull(YourExpression) = -1,'NA', YourExpression)

Hope this helps

Thanks & Regards

MK_QSL
MVP
MVP

Can you provide your expression here?

MK_QSL
MVP
MVP

Try as below

IF(YourExpressionofDenominator = 0, 'NA', YourFullExpression)

nizamsha
Specialist II
Specialist II

if its possible mean can u post sample qvw

Not applicable
Author

if(count(PCF_Complaint_No)=0,100,

if((count({<[Dealer PCF Activity Result]={'Successful'}>} PCF_Complaint_No)+count({<[Dealer PCF Activity Result]={'Dropped'},[Dealer Reason for Call Drop]={'System Dropped'}>} PCF_Complaint_No))=0,'NA',

(count({<[Dealer Customer Satisfaction]={'Satisfied'}>} PCF_Complaint_No)/(count({<[Dealer PCF Activity Result]={'Successful'}>} PCF_Complaint_No)+count({<[Dealer PCF Activity Result]={'Dropped'},[Dealer Reason for Call Drop]={'System Dropped'}>} PCF_Complaint_No)) * 100))

Anonymous
Not applicable
Author

If you can create variables for long expression, then it would be easy to maintain. You can create one variable for numerator and one for denominator. You can try below expression if it helps you.

if(count(PCF_Complaint_No)=0,100,

if((count({<[Dealer PCF Activity Result]={'Successful'}>} PCF_Complaint_No)+count({<[Dealer PCF Activity Result]={'Dropped'},[Dealer Reason for Call Drop]={'System Dropped'}>} PCF_Complaint_No))=0 OR
IsNull(count({<[Dealer PCF Activity Result]={'Successful'}>} PCF_Complaint_No)+count({<[Dealer PCF Activity Result]={'Dropped'},[Dealer Reason for Call Drop]={'System Dropped'}>} PCF_Complaint_No)),'NA',

(count({<[Dealer Customer Satisfaction]={'Satisfied'}>} PCF_Complaint_No)/(count({<[Dealer PCF Activity Result]={'Successful'}>} PCF_Complaint_No)+count({<[Dealer PCF Activity Result]={'Dropped'},[Dealer Reason for Call Drop]={'System Dropped'}>} PCF_Complaint_No)) * 100))

Not applicable
Author

Hi All,

I tried Isnull, ALT  functions as you suggested, but still its not working. i think in chart its not Possible.when i change the chart into a Straight table all these functions are working with the same expression..