Solved: Re: cumulative date - Qlik Community

souadouert · ‎2017-03-31

Good morning

I have a cross table, I want when I select a date, a column displays the realization --> the date of selection and a column displays the cumulative from the beginning 2017 until the selected date

thank you

souadouert · ‎2017-03-31

Sunny i

I used this expression, you think it is a solution does not generate problems later

=sum(if(Year(Date#(getfieldselections(SITUATION_PRODUIT), 'YYYY-MM')) ='2016'and MONTH(Date#(getfieldselections(SITUATION_PRODUIT),'YYYY-MM')) <=Month(Date#(SITUATION_PRODUIT, 'YYYY-MM')), REAL_PACKS.NOMBRE_PACK))

View solution in original post

Anil_Babu_Samineni · ‎2017-03-31

May be this?

Sum({<date = {">=Yearstart(date) <=Max(date)"}>} Sales)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

souadouert · ‎2017-03-31

anil i want compare the year of date selection >2017 until the selected date

Anil_Babu_Samineni · ‎2017-03-31

May be i am not follow you, Would you provide more input on this. Better with few rows and expected result to see while selection happen

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

sunny_talwar · ‎2017-03-31

Are you looking to get YTD current year? What is your chart dimension?

souadouert · ‎2017-03-31

for exemple sunny i selected fev 2017 , so a column displays the realisation (fevr 2017) and other column (janv+fevrier 2017)

sunny_talwar · ‎2017-03-31

So, MonthYear is not a dimension? You want two expressions, 1 which gives the current monthyear and the other which is YTD (Year-to-date)?

souadouert · ‎2017-03-31

I will try with your method

souadouert · ‎2017-03-31

hello sunny

How to extract the month of a date as yyyy-mm??

sunny_talwar · ‎2017-03-31

Like this

Date(MonthStart(DateField), 'YYYY-MM')