calculation on Variables

balrammahato204 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Please help me for below requirement.

I have created the variable for each month of the year and assigning a flag value as per condition.(This is happening on script level and variables are creating dynamically and assigning a value). Now i want to check all these variables and assigned a value true if all months variable Flag value having the "True" or assign False if any of the month variable value is having false value.

Below is the logic to create the dynamic variable.

Table1:

'vValue'&Applymap('Test',Month_Year,Null()) as VMonthYear

'=Sum({<Month_Year={#('&'vValue'&ApplyMap('Map_MonthYear',Month_Year,Null())&')}>}Total)' AS vMonthYearValue

Resident Temp;

FOR h=0 to NoOfRows('Table1')-1

let PerVaribleName = Peek('vMonthYear', h, 'Table1');

let PerVaribleValue = Peek('vMonthYearValue', h, 'Table1');

Next h;

Let '$(PerVaribleName )' = replace('$(PerVaribleValue )','#','$');

Using above code variable name and calculated value able to get on corresponding variable in the UI variable overview.

Now i want to check all variable value and create a new variable and assigned a true false as per my above explanation.

Please let me know if required any more clarification on this requirement.

Regards

Balram

topic calculation on Variables in QlikView

calculation on Variables