Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
utilities
Not applicable

List the Selected month VS previous months charges and the differences

Hello all, I have just started using QS and would like to try and generate an app as above where I can select a month and the app is to list the Selected month VS Previous months charges and the difference between the two for each measure/charge.

I have played around with the settings but cannot find anything to accomplish this.

Thanking you in advance.

Regards

Deon

2 Replies
Gysbert_Wassenaar
Not applicable

Re: List the Selected month VS previous months charges and the differences

If you select one specific month you can use expressions like

Selected month: sum( charges )

Previous month: sum( {<PeriodID=P(PrevPeriodID)>}charges )

Difference: rangesum(sum( charges ), -sum( {<PeriodID=P(PrevPeriodID)>}charges ) )


talk is cheap, supply exceeds demand
utilities
Not applicable

Re: List the Selected month VS previous months charges and the differences

Hi Gysbert, thank you for the reply.

It seems that this will work although I am very novice to QS and not even sure where or how to implement this, so I am still working on it.

Regards