Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Not equal <> is not working at script level varaible

below expression is not working at script level.

LET vWeek_End_Not <> date(max(week_ending)-7,'DD/MM/YYYY')

2 Replies
Highlighted
Specialist III
Specialist III

Hello,

What about you change things like this?

LET vWeek_End_Not = date(max(week_ending)-7,'DD/MM/YYYY');

 

Then  you put it into a where clause, for instance:

Load 

Your_Fields

From your_db where week_ending <> '$(vWeek_End_Not)';

Try this out and tell us what happened.

Regards

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
Highlighted

Hi @Abhi999 

LET vWeek_End_Not <> date(max(week_ending)-7,'DD/MM/YYYY')

Max function not work in "Let" statement. 

You need to try like below

Load max(week_ending) as MaxWeek resident yoursourcetable;

Let vWeek_End_Not  = Date(Peek('MaxWeek')-7,'DD/MM/YYYY');

Load

* from your_Sourcetable where week_ending <> '$(vWeek_End_Not)';

Hope it helps

Thanks & Regards,
Mayil Vahanan R