topic Re: Line chart expression in QlikView

Line chart expression

Tue, 11 Sep 2012 05:48:17 GMT

Hi All,

I am developing line chart in my application,my requirement is current month sales in 1 line, last month sales is 2nd line and lastyear same month is 3rd line.

I taken date as a dimension.how can i write the expression for representing this three lines in chart.

can anyone having idea of this.thanks in advance..

regards,

baru

Re: Line chart expression

whiteline — Tue, 11 Sep 2012 06:09:30 GMT

Use set analysis in your expresions.

Re: Line chart expression

Tue, 11 Sep 2012 06:40:22 GMT

Hi Whiteline,

Thanks for your reply,

can i have one example for this 3 expressions

regards,

baru

Re: Line chart expression

whiteline — Tue, 11 Sep 2012 06:50:21 GMT

I can give you only a general example as I don't know you fields name, data and all of your requrements.

It strongly depends on how you handle dates, date formats and so on.

=Sum({$<Month={"=Month=Month(Today())"}>} Sales)

=Sum({$<Month={"=Month=Month(Today())-1"}>} Sales)

=Sum({$<Month={"=Month=Month(Today())-1"}, Year={"=Year=Year(Today())-1"}>} Sales)

The above expressions will work only if you have month as number and year as number.

There is a plenty of examples in help (search set analysis).