topic Re: Line graph in QlikView

Line graph

padmanabhan_ram — Tue, 15 Sep 2015 10:20:07 GMT

Hi All,

I have a requirement to show six months in the dimension in a line graph but the expression should be able to calculate all the year data.

Attached file for your reference. Could you please help to get the expected output.

Regards,

Padmanabhan

gautik92 — Tue, 15 Sep 2015 10:21:12 GMT

can yu attach sample qvw ??

padmanabhan_ram — Tue, 15 Sep 2015 10:52:18 GMT

Please find the attached qvw. !

jonathandienst — Tue, 15 Sep 2015 11:08:18 GMT

You need to convert your MonthName field to a dual date format. Something like this will do it

LOAD Brand,

Date#(MonthName, 'MMM-YY') As MonthName,

Value

INLINE

[

Brand, MonthName, Value

...

Now for the last 6 months, you can use AddMonths in a set expression, like this:

SUM({<MonthName = {">$(=Date(AddMonths(MonthName, -6), 'MMM-YY'))"}>} Value)

And you should sort the field numerically.

padmanabhan_ram — Tue, 15 Sep 2015 12:07:11 GMT

Hi Jonathan,

Thanks for the response. I want for six months but not for last six months, it is like alternate months.

And if I apply the above as you said, it gives no data to display.

Regards,

Padmanabhan