topic Re: Header/Label Help in QlikView

Header/Label Help

Anonymous — Mon, 21 Mar 2016 16:04:48 GMT

Hi All,

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.

Many Thanks,

Frank

Re: Header/Label Help

sunny_talwar — Mon, 21 Mar 2016 16:11:32 GMT

The labels can only be used within the same chart and not outside. Can you use variables instead?

Re: Header/Label Help

Anonymous — Mon, 21 Mar 2016 16:31:17 GMT

Yes, I did use variables and it works. I'm just curious if it's doable within Qlik objects.

BTW - what's the label syntax within the same chart? I used column(). Thanks

Re: Header/Label Help

sunny_talwar — Mon, 21 Mar 2016 16:33:15 GMT

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)

Re: Header/Label Help

sfatoux72 — Mon, 21 Mar 2016 16:41:00 GMT

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.

Re: Header/Label Help

Anonymous — Mon, 21 Mar 2016 16:48:38 GMT

Thanks Sunny!!.. I shouldn't ask you this question..

Re: Header/Label Help

Anonymous — Mon, 21 Mar 2016 16:50:20 GMT

Sebatien, I agree label over Column().

Is there ways to lock the column's to prevent user moving the columns?

Re: Header/Label Help

sfatoux72 — Mon, 21 Mar 2016 17:57:40 GMT

‌yes,

properties --> presentation --> disable "Allow move column"