Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

New Contributor III

Monthwise Amount expressions according to fin year

Dear All,

I have 1 selections, End Date.

I want a report in which i want to show month wise expressions starting from the first  fin month i.e apr till mar.(no month dimension)

So there will be 12 expressions in this report.

when i select end date as 30 apr 2011 then it should show data only in apr expression.

when i select 15 jun then ,data will be shown in apr column from 1-04-2011 till 30 - 05-2011 ,in may column from 1-05-2011 till 31-05-2011 and in jun column from 1-6-2011 till 14-06-2011 ,rest all month expr will have 0 value.

In short ,the 12 columns will be filled with amount according to the End date.

Community Browser