Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
balrammahato204
Creator
Creator

calculation on Variables

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 

0 Replies