Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
USE BELOW IN Expression
ALT(yourexpression, 0)
or
ALT(yourexpression, 'NA')
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
Try like this
If(Isnull(YourExpression) = -1,'NA', YourExpression)
Hope this helps
Thanks & Regards
Can you provide your expression here?
Try as below
IF(YourExpressionofDenominator = 0, 'NA', YourFullExpression)
if its possible mean can u post sample qvw
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))
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))
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..