topic Re: count shows incorrect in chart in QlikView

count shows incorrect in chart

arulsettu — Wed, 25 Nov 2020 16:16:04 GMT

hi 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

expected result

Re: count shows incorrect in chart

arulsettu — Thu, 03 Mar 2016 10:40:35 GMT

Bill Markham ‌ can you take a look

Re: count shows incorrect in chart

MK_QSL — Thu, 03 Mar 2016 10:42:48 GMT

use this.. already replied you in previous post.

Re: count shows incorrect in chart

sunny_talwar — Thu, 03 Mar 2016 10:50:06 GMT

Are you looking to fix the straight table or the bar chart? They both have different expressions and I am having a hard time understanding what are we trying to fix here

Re: count shows incorrect in chart

arulsettu — Thu, 03 Mar 2016 10:50:14 GMT

one problem bro. if i clear the selection vech count is changing. only i select year 2016 it showing correct values. can you please take look

Re: count shows incorrect in chart

arulsettu — Thu, 03 Mar 2016 10:50:44 GMT

only in bar chart Sunny

Re: count shows incorrect in chart

sunny_talwar — Thu, 03 Mar 2016 11:01:15 GMT

May be like attached

Re: count shows incorrect in chart

arulsettu — Thu, 03 Mar 2016 11:05:08 GMT

Sunny you didnt use cyclic group in bar chart?

Re: count shows incorrect in chart

MK_QSL — Thu, 03 Mar 2016 11:08:20 GMT

use this !

Re: count shows incorrect in chart

arulsettu — Thu, 03 Mar 2016 11:12:49 GMT

{"=Rank(COUNT({1<BW_FM_DT_YEAR = {'$(=Max(BW_FM_DT_YEAR))'}>}BW_VEH_ID))<=10"}

1 -> this the change u made right?

Re: count shows incorrect in chart

sunny_talwar — Thu, 03 Mar 2016 11:14:00 GMT

Check now

Re: count shows incorrect in chart

arulsettu — Thu, 03 Mar 2016 11:35:25 GMT

Thanks guys