topic Re: Bar Chart Max Value in QlikView

Bar Chart Max Value

selcukcadir — Thu, 13 Nov 2014 08:19:08 GMT

Bar Chart Max Value

Hi all,

How can we solve the problem in the attached document?

Thanks...

its_anandrjs — Thu, 13 Nov 2014 08:27:26 GMT

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 — Thu, 13 Nov 2014 08:28:22 GMT

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

sujeetsingh — Thu, 13 Nov 2014 08:33:05 GMT

What you really want can you come back in more words

ashfaq_haseeb — Thu, 13 Nov 2014 08:36:21 GMT

Hi,

Check this

Regards

ASHFAQ

its_anandrjs — Thu, 13 Nov 2014 08:38:41 GMT

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 — Thu, 13 Nov 2014 09:12:29 GMT

Reference line label

Max value = 2 and max month Jan

could it be?