Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to change the Y axis values in bar chart?

Hi,

I have a bar chart with below

Dimension1: Month

Dimension2: =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek)

Expression as below:

% of Fail: Count({<[Overall Result]={'Fail'}>} Distinct [ID])/Count(Distinct([ID]))
Number Review:Count(Distinct([ID]))

Number of Fail: Count({<[Overall Result]={'Fail'}>}DISTINCT [ID])

In bar chart the Y axis values are showing as 0%,100%,200%,300%,400% and so on up to 1,200%

There are Number of Fail as 2. Because of this the Number of Fail is not showing? Is there any way that I can change the Y axis values?

Thanks.

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

First you need to make all your different date formats to single date format...

I have done the same in enclosed file.

Now rest you can do yourself.

View solution in original post

15 Replies
MK_QSL
MVP
MVP

as usual, share your sample data file..

its_anandrjs
Champion III
Champion III

Use chart properties -> Values on data point -> Plot value inside Segments.

Hope this helps

Thanks & Regards

MayilVahanan

Hi

Try like this

Chart properties -> Axis -> Expression Axes -> Scale

In that, give static step , static min and static max.

Hope that helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Please find attached.

MK_QSL
MVP
MVP

Thanks for your file.

Can you explain what exactly you want?

MK_QSL
MVP
MVP

Why you dont get fail is because there is a problem in your data model.

Create a list box of overall result and select Fail...

you can see that the Date coming is in numeric format... May be you need to set your date as

Date(Date, 'DD/MM/YYYY') as Date in your script....

its_anandrjs
Champion III
Champion III

Hi,

Your date field is not correct they contains number date and date field for single date format change in your load script for Date field like

Date(Date#(Date,'DD/MM/YYYY'),'DD/MM/YYYY') as Date

Hope this helps

Thanks & Regards

its_anandrjs
Champion III
Champion III

Check your date field of Data table which is cross table in source there is a problem.

Hope this helps

Not applicable
Author

Thanks. Yes you are right. I changed my Date field. But still showing the same result. Any solution please?

EDIT:  I can able to see the count of Fail in straight table. But the problem is with Bar chart?