I've been looking for a solution to this, but did not find anything on qlik community nor outside of it, does anyone know if it can be solved?:
I've a table with year and quarterly data that has the following columns:
sales_q_1, sales_q_2, sales_q_3, sales_q_4, costs_q_1 [, .... 4], etc.
Now i'm doing a table with dimension quarter (1,2,3,4),
Is it possible to have the expression something like 'Sales_q_' & quarter - so that the field name is evaluated four times, as per each quarter?
I tried the expressions as in this thread (this is the closest i found): dynamic field name
With something like Sum($(sales_q_'&quarter)) and various other attempts, but i cannot get it working, am i doing something wrong, or is it not achievable?
yes, like this:
if (quarter=1, sales_q_1, if (quarter=2, sales_q_2, if (quarter=3, sales_q_3, sales_q_4)))
But i was thinking something more elegant, a single expression like
yes i understand you,
another option to use only One if, is to concatenate the line of Sales_Q to remove the number from that field and replace it with a second field containing only the number of the quarter..
like that you will have:
if( Quarter = $(vQuarter), Sales_Q)
Youssef, I'm sorry, you're missing the point, i don't need any If's,
I need to display all quarters sales,
The dimension is Quarter, with values: 1,2,3,4.
Can i have an expression, that builds the field name from this quarter value: e.g.: sales_q_[QUARTER] ?
i would see this valid only when i load already all field names transformed into a single one,
e.g. load 1 as quarter, sales_q_1 as sales, load 2 as quarter, sales_q_2 as sales, etc.
But i have the field names as stated: sales_q_1, sales_q_2, sales_q_3, etc.
Quick through why don't you try to use Cross Table Concept
Like Quarter field : Values Q1 ,Q2 ,Q3 and Q4
and Sales Field : Sales of each Quarter .
if you can attach sample data it will be helpful.
maybe i'm missing something ?