Discussion Board for collaboration related to QlikView App Development.
I have 20 fields like A,B,C,D,E,F.... etc.
then i created a inline table to get a dimension with the name above fileds.
load * inline[
Now i want to create a table. so i write expression like
so i need instead of write separate expression for each dimension value, can i get common expression like below
sum(max(field_Name)) or Sum(only(field_Name)) or can use variable?
how can i get field name from field value?
But neither of these will work unless there is one and only one possible value of field_Name (eg by selecting one value from the list).
If you want to display all of them in a table, load the data like this:
LOAD Dual(field_Name, RowNo()) as field_Name
Create a table with field_Name as dimension, and use the expression:
I think this won't be possible because the $-sign expansion will be globally calculated and contained then as an adhoc-variable a single-value - it won't be calculated in respect to any dimensions.