Solved: showing incorrect count - Qlik Community

arulsettu · ‎2016-03-03

hi i am doing simple count

count(id) and for ratio count(id)/count(total id)

count(total Id) is incorrect.

in straight table i checked.in properties expression tab if i use Expression as total it showing correct.

how to do this bar chart.

Note: i am using cyclic group in dimension

t_chetirbok · ‎2016-03-03

for ratio use expression

If(Rank(count(BW_VEH_ID), 4, 1) <= 10,

count(BW_VEH_ID)

/sum(TOTAL aggr(If(Rank(count(BW_VEH_ID), 4, 1) <= 10,count(BW_VEH_ID)) ,BW_MAKE_DESC) )

)

MK_QSL · ‎2016-03-03

Provide sample data !

MK_QSL · ‎2016-03-03

Can you tell us where you think it is wrong? What is the exact result according to your need?

arulsettu · ‎2016-03-03

please check the count total. all vech count

arulsettu · ‎2016-03-03

total should be 31057 for year 2016

MK_QSL · ‎2016-03-03

How 31057?

t_chetirbok · ‎2016-03-03

Why?

total count is 43471

jagan · ‎2016-03-03

Hi,

43417 is correct value. Not sure do you missed any filters in the expression or script?

Regards,

jagan.

arulsettu · ‎2016-03-03

Hi Jagan,

No filters applied only year 2016. please manually count the 10 vech. you will get 31057

t_chetirbok · ‎2016-03-03

So, in your bar chart 2 expression with different format, for first axes should be 0-10000, for second 0 %- 100%.

Maybe second expression can be Text as Pop-Up for example

showing incorrect count