topic Re: Sum with Variable in QlikView

Sum with Variable

Anonymous — Mon, 07 Mar 2016 11:46:49 GMT

Hi All

I am trying to sum Sales for current month previous month and 2 months ago

I have variables for this and am doing the following

=(Sum({<$(vCurrentMonth) Collections))

=(Sum({<$(vPreviousMonth) Collections))

but this does not work any idea how to do this please?

Thanks alot!

kaushiknsolanki — Mon, 07 Mar 2016 11:48:19 GMT

Hi,

Try this way.

Sum({<Month = {"$(vCurrentMonth)"}>}Collections)

Sum({<Month = {"$(vPreviousMonth)"}>}Collections)

Regards,

Kaushik Solanki

Gysbert_Wassenaar — Mon, 07 Mar 2016 11:50:14 GMT

Maybe like this:

=(Sum({<Month={$(vCurrentMonth),$(vPreviousMonth)}>} Collections))

MayilVahanan — Mon, 07 Mar 2016 11:56:38 GMT

Try like this

Sum({<Month={$(vCurrentMonth),$(vPreviousMonth), $(v2MonthAgo)}>} Collections)

Anonymous — Mon, 07 Mar 2016 12:05:58 GMT

Thanks All

This has worked !!!

Thanks

Kaushik Solanki