Using a variable with field without any aggregation functions

Thu, 17 Feb 2011 07:54:58 GMT

Imagine if the field name is ABC which contains sales value. I want to calculate the sale of the CurrentYear and CurrentMonth. So I have created 2 variables, one to calculate the CurrentYear(vCurrentYear) and other to calculate the CurrentMonth(vCurrentMonth).

Currently in expression, I have put 'ABC' as it is the field name.

I want to do his I want to pass this variable in to the expression so that it gives the sales of the CurrentYear and CurrentMonth. Below variable works fine in if condition. How could I use that without any if condition or (Sum or Count).


{<[FINISHMONTH] = {'$(vCurrentMonth)'}, [FINISH_YEAR] = {'$(vCurrentYear)'}>}

What I mean to say is that

In expression it is: ABC

I want to pass the above variable with that so that it gives the sales of the CurrentYear and CurrentPeriod.

I did some like below in the expression. (I know it doesn't work like that. Just copied for your understanding what exactly I wants.)

Expression: {<[FINISHMONTH] = {'$(vCurrentMonth)'}, [FINISH_YEAR] = {'$(vCurrentYear)'}>}ABC

Hope that some one can help me out on this.

Using a variable with field

maneshkhottcpl — Thu, 17 Feb 2011 08:39:53 GMT

{<[FINISHMONTH] = {'$(#vCurrentMonth)'}, [FINISH_YEAR] = {'$(vCurrentYear)'}>}

Using a variable with field

Thu, 17 Feb 2011 08:45:01 GMT

Please send me the complete code. You didn't pass ABC field with that.

topic Using a variable with field in QlikView

Using a variable with field without any aggregation functions

Using a variable with field

Using a variable with field