Getting 0 for previous month Sales when selecting month filter in Qliksense

[venky77777]

Hi,

Can you help me on getting 0 for previous month Sales when selecting month in month filter.

Whenever selecting or changing month in month filter only current month total sales is showing, prev month sales showing 0. If I select 2 months in month filter the both values are showing.

Prev Month-----Sum({< PDate = {">=$(=date(monthstart(Max(PDate),-1),'DD-MM-YYYY'))<=$(=date(monthend(Max(PDate),-1),'DD-MM-YYYY'))"},PDate= >} Sales)

without selecting Month in filter

After selecting month in filter

[Antoine04]

Try with  "Month=" in your set analysis, something like :

Prev Month-----Sum({< PDate = {">=$(=date(monthstart(Max(PDate),-1),'DD-MM-YYYY'))<=$(=date(monthend(Max(PDate),-1),'DD-MM-YYYY'))"},PDate=, Month= >} Sales)

Regards

Antoine

[venky77777]

If I add month=,Pdate= then I'm getting some random value as in below image

Actual Prev. value is 113123.7. Can any one help on this.