By linking incident name you can get the incident value
LOAD * INLINE [
'Ind_'&Indication&'_Time' AS Indication_name
//[..\Desktop\Qlikview Project\test\test tussentotaal herbruiken.xlsx]
(ooxml, embedded labels, table is Blad1);
Check the attachment and let me know is this your requirement?
test_dynamic_fieldname.qvw 143.0 K
Not exactly, I want to use this into a larger expression/formula. Something like this:
But I didn't made a correct test-version. The version I uploaded now (test_dynamic_fieldname_2), is the correct version.
You will see 4 listboxes where the user can select a value and I want that value into an expression in the pivot table.
Let me know if you need more explanation!