Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
selcukcadir
Creator II
Creator II

Bar Chart Max Value

Bar Chart Max Value

Hi all,

How can we solve the problem in the attached document?


Thanks...

exp.png

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Hi,

Check this

Regards

ASHFAQ

View solution in original post

6 Replies
its_anandrjs

Hi,

It is not very clear but it seems you need one extra bar column with all bar if so

Add another expression as and check what output you get

=Max(Aggr((sum(TOTAL value1) / sum(TOTAL value2)),MonthDate ))

Regards

Anand

MK_QSL
MVP
MVP

Max(Total Aggr(sum(value1) / sum(value2),MonthDate))

sujeetsingh
Master III
Master III

What you really want can you come back in more words

ashfaq_haseeb
Champion III
Champion III

Hi,

Check this

Regards

ASHFAQ

its_anandrjs

Hi,

If you need for over all values then try with because Max value you shown i believe as reference line.

=Max(Total Aggr((sum(value1) / sum(value2)),MonthDate ))

Regards

Anand

selcukcadir
Creator II
Creator II
Author

Reference line label

Max value  = 2 and max month  Jan

could it be?