How to add current month and forward in time till the year end

Ask a Question

Hi all,

I wanted to know how to add current selecting of month and all the months afterwards till the end of the fiscal year in Qlikview .

For e.g. If I have an amount for Dec, Jan, Feb, and Mar as 100, 200, 300 and 400 respectively. When a user select Dec, it should calculate all from Dec-Mar and displays 600. If a user select Feb, it should display 700 (Feb and Mar). I am using Apr - Mar fiscal year.

Can anybody help me please?

Thanks,

Wossen

0 Replies