Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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

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

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

subhasmita_kar
Creator
Creator

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

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