topic Max month bar chart in QlikView

Max month bar chart

Srinivas — Fri, 27 Nov 2015 08:54:50 GMT

Hi All,

I have one chart , that chart would shows all months data but i need max month data only means one bar chart,

Pleased find the attached one.

Re: Max month bar chart

Gysbert_Wassenaar — Fri, 27 Nov 2015 09:09:59 GMT

See attached example.

Re: Max month bar chart

its_anandrjs — Fri, 27 Nov 2015 09:11:32 GMT

Hi,

In your Qlik file add Num field for Month field like

Date:

LOAD Date,

ID,

Year(Date) as Year,

Month(Date) as Month,

NUM(Month) as NumMonth,

Sales

FROM

(ooxml, embedded labels, table is Sheet1);

And in expression use it like

sum({<Year ={$(=max(Year))}, NumMonth ={$(=max(NumMonth))}>}Sales)

Regards

Anand

Re: Max month bar chart

prma7799 — Fri, 27 Nov 2015 09:15:12 GMT

PFA...

Re: Max month bar chart

its_anandrjs — Fri, 27 Nov 2015 10:09:24 GMT

Also you can use same Month field also see the attachment

And use the expression

sum({<Year ={$(=max(Year))}, Month ={$(=Month(Date#(Max(NUM(Month)),'M')))}>}Sales)

Regards

Anand

Re: Max month bar chart

Anonymous — Fri, 27 Nov 2015 11:14:47 GMT

Hi,

Please refer attached .qvw file.

Thanks

Re: Max month bar chart

nagarjuna_kotha — Fri, 27 Nov 2015 11:42:34 GMT

Hi,

PFA.....

Regards,

Nagarjuna

Re: Max month bar chart

nagarjuna_kotha — Fri, 27 Nov 2015 12:24:36 GMT

Hi Srinivas ,

If you got your answer.Kindly close this tread.

Regards,

Nagarjuna

Re: Max month bar chart

Srinivas — Sun, 29 Nov 2015 15:40:14 GMT

Hi nagarjuna,

initially i want to show single bar means max month , after that according to selections i want to show all bars

like below image is showing single month data ..

if i select multiple selection then it will show multiple bars like

Regards

srinivas

Re: Max month bar chart

nagarjuna_kotha — Mon, 30 Nov 2015 05:39:36 GMT

You can achieve this,

PFA below atttached,

In that If you did nit select any month it will only max Month data only, if you select months accordingly it give .

_Nagarjuna

Re: Max month bar chart

nagarjuna_kotha — Mon, 30 Nov 2015 05:44:03 GMT

If you dont want two expressions you can also do tht in single expression also.

Example:

If(Getselectedcount(Month<0 ,(Exp 1),(Exp 2))

Let me know if you facing any issues

-Nagarjuna

Re: Max month bar chart

Srinivas — Mon, 30 Nov 2015 11:38:36 GMT

Hi Nagarjuna,

when i am applying into my application it's not working , I have two dimensions and one expression.

Thanks in Advance

Srinivas

Re: Max month bar chart

nagarjuna_kotha — Mon, 30 Nov 2015 11:51:31 GMT

Hi Srinivas,

If you put second dim also it will work.If you want check in my app add ID as first dim and make selections .Its working .

-Nagarjuna