Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Need accumulation expression for ytd

Hi Team,

=Count(DISTINCT{<Incident={"=resolved_Date<=Targetdate"}>}Incident_Number)/count(DISTINCT{<resolved_Date={"*"},Targetdate={"*"}>}Incident)

I am facing a issue on finding the YTD percentages in barchart.

I need to show Month and YTD percentages  in barchart in seperate bars for every month of current Fiscal  year I.e April 2016 to March 2017

I am able to get the exact percentage values for Month bars by using above expresion.

but for YTD I am not getting correct outputs.As per my knowledge It is not taking accumulation

So can any one please give the expression for YTD by using above expression ....

The calculation of YTD would be if it is september month it should be taken from April to september

                                                                August  month     it should be taken from April to August  

There is  no filters like Month and Year

Thanks,

Chinnu

0 Replies