topic Re: Expression help in QlikView

Expression help

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i have an expression in the attached QVW (Carriage Costs), i cant get it to populate in the chart. I have it showing the correct value in a text box but i need that to appear in the chart.

I have a single item selected (05842) for customer bkryx, but i also need it to show the correct value when there are no selections on these fields.

I think its to do with the AGGR but i can't get it to work.

any help would be appreciated.

Re: Expression help

YoussefBelloum — Tue, 22 May 2018 09:39:02 GMT

Hi,

you simply have an extra S on the name of the variable inside the final expression

you put vCarriageCosts instead of vCarriageCost

Re: Expression help

hopkinsc — Tue, 22 May 2018 10:09:35 GMT

damn it!! i had 2 variables, i didnt realise the carriage cost variable had already been created, so i deleted one but forgot to change the expression! typical!

Thanks for your help.

Re: Expression help

YoussefBelloum — Tue, 22 May 2018 10:11:43 GMT

you're welcome, good luck