Max month bar chart

[Srinivas]

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.

[Gysbert_Wassenaar]

See attached example.

[its_anandrjs]

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

[prma7799]

PFA...

[its_anandrjs]

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

[Anonymous]

Hi,

Please refer attached .qvw file.

Thanks

[nagarjuna_kotha]

Hi,

PFA.....

Regards,

Nagarjuna

[nagarjuna_kotha]

Hi Srinivas ,

If you got your answer.Kindly close this tread.

Regards,

Nagarjuna

[Srinivas]

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

[nagarjuna_kotha]

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