topic Re: Logarithmic bar chart shows null dimensional value with larger count than other values is showing up at bottom/out of sort in QlikView

Logarithmic bar chart shows null dimensional value with larger count than other values is showing up at bottom/out of sort

vvira1316 — Wed, 23 Aug 2017 16:39:08 GMT

Hi,

Logarithmic bar chart shows null dimensional value with larger count than other values is showing up at bottom/out of sort

Any idea why?

Expression (same is used in Sort)

Count(

[Version]={'>0'},

[ATDS]={'Val1*','Val2*'}

>} [ID])

Thanks,

Vijay

sunny_talwar — Wed, 23 Aug 2017 16:46:07 GMT

Would you be able to post a sample?

Anil_Babu_Samineni — Wed, 23 Aug 2017 16:50:14 GMT

Have you used any scale options in Axes tab?

vvira1316 — Wed, 23 Aug 2017 17:57:27 GMT

I'm preparing it. Without calculated expression it worked fine.

vvira1316 — Wed, 23 Aug 2017 17:57:44 GMT

yes. I've static max

vvira1316 — Wed, 23 Aug 2017 19:53:46 GMT

Attached please find sample data set and QVW

vvira1316 — Wed, 23 Aug 2017 19:54:35 GMT

I've attached the sample files

sunny_talwar — Fri, 25 Aug 2017 14:20:25 GMT

May be use a calculated dimension (or changes in the script to fix this)

Calculated dimension

=If(Len(Trim(Comp)) = 0, ' ', Comp)

vvira1316 — Fri, 25 Aug 2017 15:18:15 GMT

Thanks.