Calculating Revenue in A Prior Month - Qlik Community

b01703030 · ‎2019-03-25

Greetings,

I want to calculate the revenue in a prior month, but my script didn't work.

Can anyone give me some suggestion? Thanks.

kaushiknsolanki · ‎2019-03-25

Hi,

Add below two things in your set analysis.

QtrYear=,Month=

Your expression is not getting evaluated because this field has selection in it, which creates confusion with the set analysis you have written, thus you need to neglect the selection of this field in set analysis.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!