I was trying to see if Qlik allows you to reuse the Header/Label name calculation. What I have field names, Company, Amount1, and Amount2. On one of my Table I have 2 expressions named "SumAmt1_2" and "Ratio%". I'm curios if I can type either of this expression Header on a separate table would give me the same results. Please see attached QVW.
You can use Column() or you can use what ever name you have give it.
For instance if you call your expression Name XYZ -> You can refer it in other expression by calling [Name XYZ] (it will turn blue if it find the label name)
You can use Column() or you can use what ever name you have give it.
For instance if you call your expression Name XYZ -> You can refer it in other expression by calling [Name XYZ] (it will turn blue if it find the label name)
The advantage of using label is that you could let your user play with column order without impact the result of your expression. With Column(), you must remove the possibility to move the column to avoid wrong result.
