topic Re: Previous month selection issue in QlikView

Previous month selection issue

saradhi_it — Sat, 16 Nov 2024 17:32:39 GMT

HI team

I Have two years of data From Jan 2018 to Dec 2019, i got a requirement from the user when the user selects any month filter (list box or filter pane) data should be calculated from Mindate to the previous month based on the current selection

Eg: if user selects Dec 2019 data should be calculated from Jan 2018(Min date) to Nov 2019

i tried so many expressions

COUNT(distinct {<current_Month={"${=Date(MonthStart(max(current_Month), -1),'MMM-YY'))"},Status={'Confirmed '}>} Sales)

I had tried my expressions didn't work

Re: Previous month selection issue

PriyankaShivhare — Tue, 02 Feb 2021 02:26:22 GMT

May be like this:

sum({<Date={">$(=min({1}Date))<$(=addmonths(max(Date),-1))"},Status={'Confirmed'}>}Sales)

sum({<Date={"<=$(=addmonths(max(Date),-1))"},Status={'Confirmed'}>}Sales)

count({<Date={">$(=min({1}Date))<$(=addmonths(max(Date),-1))"},Status={'Confirmed'}>}Distinct [DimensionField])

Check for the Date format:

Thanks,

Priyanka