topic Re: Expression vs Scripting in QlikView

Expression vs Scripting

aetingu12 — Sat, 16 Nov 2024 03:45:44 GMT

All, I am trying to copy and expression I have within one of my created fields:

=if(MATCH(FRUIT,'APPLE') AND MATCH(SEASON, 'SUMMER') AND NOT MATCH(RAIN, 'NO') AND MATCH(LOCATION,'UK'), Dual('LC',1),0)

This within a Field Expression works perfectly. Creates a Field that has LC and Other and when select LC, I can see all the filters. ie. FRUIT is APPLE, SEASON is SUMMER etc.

But when I move this expression in to a load script to create a column. The filtration does not work.

Any help is much appreciated,

Aksel

Re: Expression vs Scripting

sunny_talwar — Thu, 25 Apr 2019 10:40:54 GMT

Would you be able to share a sample where we can see the issue?

Re: Expression vs Scripting

Claudiu_Anghelescu — Thu, 25 Apr 2019 10:48:06 GMT

You can try this:

=if(FRUIT ='APPLE' AND SEASON= 'SUMMER' AND RAIN <> 'NO' AND LOCATION ='UK',
1,0) as LC

Re: Expression vs Scripting

aetingu12 — Thu, 25 Apr 2019 10:55:35 GMT

Hi Sunny,
Thanks for getting back to me. I have added a testing file. There you will see the Season (new column) as expression and the Testing which is the same expression through scripting. the column I have created through scripting doesn't' seem to work

Re: Expression vs Scripting

sunny_talwar — Thu, 25 Apr 2019 11:00:28 GMT

So, essentially you are looking for the values within FRUIT and LOCATION to be selected when you click on the SEASON list box? You can do this using triggers, but one thing to note here is that when you select within Testing, the possible values are the same values which are selected when you select in SEASON (calculated list box). It means that you should still be able to see the result for only those FRUIT and LOCATION which are possible when you select Testing.