topic Re: Display in Barchart in QlikView

Display in Barchart

Fri, 28 Mar 2014 07:11:24 GMT

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

Re: Display in Barchart

MK_QSL — Fri, 28 Mar 2014 07:13:33 GMT

USE BELOW IN Expression

ALT(yourexpression, 0)

ALT(yourexpression, 'NA')

Re: Display in Barchart

Fri, 28 Mar 2014 07:21:21 GMT

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

Re: Display in Barchart

its_anandrjs — Fri, 28 Mar 2014 07:25:59 GMT

Try like this

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

Hope this helps

Thanks & Regards

Re: Display in Barchart

MK_QSL — Fri, 28 Mar 2014 07:28:21 GMT

Can you provide your expression here?

Re: Display in Barchart

MK_QSL — Fri, 28 Mar 2014 07:29:44 GMT

Try as below

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

Re: Display in Barchart

nizamsha — Fri, 28 Mar 2014 07:32:27 GMT

if its possible mean can u post sample qvw

Re: Display in Barchart

Fri, 28 Mar 2014 07:35:12 GMT

if(count(PCF_Complaint_No)=0,100,

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

Re: Display in Barchart

Anonymous — Fri, 28 Mar 2014 08:50:01 GMT

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',

Re: Display in Barchart

Fri, 28 Mar 2014 09:19:21 GMT

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

Re: Display in Barchart

VishalWaghole — Fri, 28 Mar 2014 10:21:27 GMT

Hi Reena,

You can try with this logic,

if((YourExpression > 0 and not isNull(YourExpression)),YourExpression,'NA')

- Regards,

Vishal Waghole

Re: Display in Barchart

Fri, 28 Mar 2014 10:24:15 GMT

you can write it as follows:

=if(yourexpression=0,NA,yourexpression)

Hope it work.

Re: Display in Barchart

Fri, 28 Mar 2014 11:53:10 GMT

Hi,

I Think to display NA is not possible in Chart but you can do something below..

* inline
[
Mnth,value1,value2
Jan, 100,50
Feb,50,25
Mar,10,0
Arp,50,
May,40,2
];

Re: Display in Barchart

manojkulkarni — Fri, 28 Mar 2014 12:07:15 GMT

I don't think you can display 'NA' as value for the particular month where its value is 0 or null. Since the chart represents numeric value. You can display 0 as it is by checking the option 'Zero on Bars'

Re: Display in Barchart

DavidFoster1 — Fri, 28 Mar 2014 12:47:37 GMT

Hi Reena

You can use the trick that Stephen Redmond put in his cookbook.

Use a DUAL function for the values and make sure the number format is 'default' and you can show text in the datapoint values.

Re: Display in Barchart

Fri, 28 Mar 2014 12:55:36 GMT

Hi,

it would be helpful, if you can provide me a sample expression .

Re: Display in Barchart

DavidFoster1 — Fri, 28 Mar 2014 13:08:55 GMT

Hmmmm something liike:

DUAL(

//Text Element

IF(ISNULL(<YourField>),'N/A',Num(Sum(<YourField),'#,##0'),

//Numeric Element

ALT(<YourField>,0)

)

And remember to leave the number formatting in the chart properties tab set to 'default' or the chart disregards the Text element of DUALs and just uses the Numeric element