topic Re: Sum of Variable Name Field in QlikView

Sum of Variable Name Field

Anonymous — Wed, 27 Mar 2013 18:10:07 GMT

I need to make a sum of one field that have the name according to the month.

In attached one example.

I tried to use three diferent types of variables, but I don't know how to make the system understand that it is a field and not a string.

Can anyone help me?

Thanks

kaushiknsolanki — Wed, 27 Mar 2013 18:26:01 GMT

Hi,

Have a look at the application.

Hope this is what you want.

Regards,

Kaushik Solanki

Anonymous — Wed, 27 Mar 2013 18:34:50 GMT

Hi Kaushik!

It is exactly that!

Thank you so much!

Regards,

Debora

rustyfishbones — Wed, 27 Mar 2013 18:46:31 GMT

Hi,

In Variable $(ROT1) you have written =Month(MonthStart(Today(), -2))

But there is no Date field in the Excel Spreadsheet and you have no Calendar created in the Script.

So I don't believe these Variables will Work.

Try changing the variables to the following

$(ROT1) as =SUM(ROT1)

$(ROT2) as =SUM(ROT2)

Then try the Expression sum_var like this =$(ROT1) + $(ROT2) and check if you get the correct result.

You will need to format COLUMN C and COLUMN F in the Excel spreadsheet as Numbers and RELOAD the Data

Hope this helps

Alan