topic Difference between two selections in App Development

Difference between two selections

Karahs — Wed, 18 May 2016 04:36:56 GMT

Hello Everyone,

I have Two columns ie. Month and Cost , i want difference on basis of my selction of month.

Eg. If i select Feb and March from Month Column i should gets the difference between them ,

If i select Jun and Jul from Month Column i should gets the difference between them .

Need to find the difference ???

Thanks

Re: Difference between two selections

Wed, 18 May 2016 04:41:27 GMT

Hi Kshitija

You can use the Month field in a listbox. So when you chose the dates in the listbox it will filter your Qlikview model to just look at that those months you selected including the difference calculation

Re: Difference between two selections

sunny_talwar — Wed, 18 May 2016 10:31:12 GMT

May be something along these lines:

Sum({<month_id = {$(=Max(month_id))}>}Sales) - Sum({<month_id = {$(=Min(month_id))}>}Sales)

Where month_id is created in the script like this:

Year*100 + Num(Month) as month_id