topic Re: How to Create A Dynamic Straight Table for Current and past 2 years..? in QlikView

How to Create A Dynamic Straight Table for Current and past 2 years..?

manozpph — Tue, 26 Aug 2014 06:47:10 GMT

I Want to Create a straight table with any dimension/s and with an expression for LineSalesAmount for each of the three years (selected year and its previous two years). If no selection has been made by the user for the year, the straight table should display the LineSaleAmount for the most recent year and its previous two years.

If anyone able to make it Please solve it.

Thanks in Advance!!

Re: How to Create A Dynamic Straight Table for Current and past 2 years..?

deepakqlikview_123 — Tue, 26 Aug 2014 06:53:51 GMT

You need to use set analyis.

Try below expressions

Current year--> sum({$<Year={$(=Max(Year))}>}LineSalesAmount)

Previous year-->sum({$<Year={$(=Max(Year)-1)}>}LineSalesAmount)

Previous to previous year-->sum({$<Year={$(=Max(Year)-2)}>}LineSalesAmount)

Thanks,

Deepak

Re: How to Create A Dynamic Straight Table for Current and past 2 years..?

manozpph — Tue, 26 Aug 2014 07:10:14 GMT

I got the Result .

Thank you