topic Re: Values showing different in Straight table and Bar chart in QlikView

Values showing different in Straight table and Bar chart

Tue, 17 Dec 2013 11:19:45 GMT

Hi,

I have a straight table with Dimension Staff member and expressions as below

Number of documents Reviewed= Count(Distinct(Reference))

Number of Failures= count({<Result={'Fail'}>}DISTINCT Reference)

% of Failures= Count({<Result={'Fail'}>} distinct Reference)/Count(Distinct(Reference))

Here Reference contains ID's

I have Bar chart with Dimension Staff member and expression as below

% of Failures= Count({<Result={'Fail'}>} distinct Reference)/Count(Distinct(Reference))

My problem is when I comapred % of Failures values in striaght table and Bar chart it is showing different percentages. Could anyone help me in this. Am I doing anything wring in the expressions? Please help.

Thanks.

Re: Values showing different in Straight table and Bar chart

Tue, 17 Dec 2013 11:23:39 GMT

can you attached your app.

Re: Values showing different in Straight table and Bar chart

nilesh_gangurde — Tue, 17 Dec 2013 11:26:10 GMT

Hi,

You can keep only one expression for % calculation in the Straight table. and chek

-Nilesh

Re: Values showing different in Straight table and Bar chart

Tue, 17 Dec 2013 11:33:50 GMT

Please find attached.

Re: Values showing different in Straight table and Bar chart

nilesh_gangurde — Tue, 17 Dec 2013 11:41:37 GMT

Hii

PFA

You have to uncheck Relative option in the Expression Tab in Bar chart.

-Nilesh

Re: Values showing different in Straight table and Bar chart

Tue, 17 Dec 2013 11:47:37 GMT

Thanks you are right and it's working.

Re: Values showing different in Straight table and Bar chart

Thu, 19 Dec 2013 13:19:39 GMT

Hi,

Is there any way to get the values correctly without uncheck Relative option in Expression tab because my user wants to have Relative option.

Thanks.

Re: Values showing different in Straight table and Bar chart

nilesh_gangurde — Thu, 19 Dec 2013 14:31:36 GMT

Hi,

Yes you can achiev that by changing the expression.

Use only 1st part of your expression and then check Mark relative option.

then your expression will be as follws:

Count({<Result={'Fail'}>} distinct Reference)

-Nilesh