Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

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

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?

LogScaleBar.PNG

Expression (same is used in Sort)

Count(

{<

[Version]={'>0'},

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

>}  [ID])

Thanks,

Vijay

1 Solution

Accepted Solutions
Highlighted

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

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

Calculated dimension

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

Capture.PNG

View solution in original post

8 Replies
Highlighted

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

Would you be able to post a sample?

Highlighted

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

Have you used any scale options in Axes tab?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Specialist II
Specialist II

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

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

Highlighted
Specialist II
Specialist II

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

yes. I've static max

Highlighted
Specialist II
Specialist II

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

Attached please find sample data set and QVW

Highlighted
Specialist II
Specialist II

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

I've attached the sample files

Highlighted

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

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

Calculated dimension

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

Capture.PNG

View solution in original post

Highlighted
Specialist II
Specialist II

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

Thanks.