How to loop through Multiple column names from excel to qliksense

[tahreen371]

Hello All,

I have been facing a lot of difficulties with this requirement.

client will make changes with column names and Column Values as per their requirement to get the Metric Value against each Metric ID, and that Risk metric excel sheet will be updated and reloaded in qliksense every time.

But the problem is under reference metric I have WildMatch Column and till now it is been coded only for one column name.

Client can add multiple column Names also under WildMatch Column.

Please let me know how can this be achieved, I have attached the Code developed by now.

Thanks & Regards

[rwunderlich]

Can you describe in business terms what you are trying to achieve?

-Rob

[tahreen371]

Hello Rob,

Its like the client wants a final result in Metric Value for the respective ID as per the conditions Applied in "Reference Data excel Sheet", Once the app is reloaded it should dynamically fetch the changes and dynamically create variables with Set Analysis equations, to evaluate the value for Metric ID.

[rwunderlich]

Assuming the values in [WildMatch Column] are separated by comma, use SubField([WildMatch Column] ,',') to generate a new row for each value.  

You'll have to decide if that will be a separate row in the output or it you put them back together as an OR. 

-Rob