topic Re: Weird Error with a Let statement? in QlikView

Weird Error with a Let statement?

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

So when I use this expression in a text sheet object it works fine, I get the value that is displayed and I have confirmed it works correctly.

But I started using it a lot so i decided to make a let expression for it. When i put it in a let statement the compiler gets angry and it has the red underline and says unknown error

//Morning INV

Let MorningINV= Sum({<DDGDayStart={'$(vToday)'}>}[DDG Inventory]);

Re: Weird Error with a Let statement?

sunny_talwar — Mon, 09 Jul 2018 13:56:12 GMT

Problem is the $ sign.... check these links for possible solutions

Expression as a variable with $-sign expansion

Stop Dollar Sign Expansion in the script (Escape Character ??? )

Re: Weird Error with a Let statement?

ali_hijazi — Mon, 09 Jul 2018 13:57:50 GMT

use set instead of let

Re: Weird Error with a Let statement?

Anonymous — Mon, 09 Jul 2018 13:58:14 GMT

Set is for Strings not expressions.

Re: Weird Error with a Let statement?

vishsaggi — Mon, 09 Jul 2018 14:16:43 GMT

You can use $ sign expansion to evaluate the expression using SET. Did you try like

SET MorningINV= Sum({<DDGDayStart={'$(vToday)'}>}[DDG Inventory]);

= $(MorningINV)

Re: Weird Error with a Let statement?

Anonymous — Mon, 09 Jul 2018 14:21:09 GMT

This is like half a solution... Thank you, i got a number but it is an incorrect number

Re: Weird Error with a Let statement?

sunny_talwar — Mon, 09 Jul 2018 14:22:22 GMT

Don't want to try what is suggested in the attached links?

Re: Weird Error with a Let statement?

Anonymous — Mon, 09 Jul 2018 14:23:00 GMT

ive been reading them but all of the proposed solutions arent working.

Re: Weird Error with a Let statement?

sunny_talwar — Mon, 09 Jul 2018 14:24:57 GMT

As in they give errors or they run but not the correct number?

Re: Weird Error with a Let statement?

vishsaggi — Mon, 09 Jul 2018 14:25:01 GMT

Ok. Can you share some sample data or file and your expected output?

Re: Weird Error with a Let statement?

Anonymous — Mon, 09 Jul 2018 14:26:38 GMT

They either give a blank text object or an expression error is displayed on the text object.

Re: Weird Error with a Let statement?

sunny_talwar — Mon, 09 Jul 2018 14:26:41 GMT

Try this

LET MorningINV = 'Sum({<DDGDayStart = {"$' & '(vToday)"}>}[DDG Inventory])';

Re: Weird Error with a Let statement?

MK9885 — Mon, 09 Jul 2018 14:27:08 GMT

Let MorningINV= ' Sum({<DDGDayStart={'$(vToday)'}>}[DDG Inventory]) ';

Maybe use ' ' ??

Whats the use of creating a variable in script when you can do it in front end, easier to modify too

Re: Weird Error with a Let statement?

sunny_talwar — Mon, 09 Jul 2018 14:33:34 GMT

Give this a short

LET MorningINV = 'Sum({<DDGDayStart = {"$' & '(vToday)"}>}[DDG Inventory])';

Re: Weird Error with a Let statement?

Anonymous — Mon, 09 Jul 2018 14:38:03 GMT

This worked!! Thank you!

Re: Weird Error with a Let statement?

sunny_talwar — Mon, 09 Jul 2018 14:46:34 GMT

Used the same logic from what was given by Stefan here

Expression as a variable with $-sign expansion