Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasshana
Creator III
Creator III

Looking for equivalent expression of set analysis in load script

Hi,

I do have the below set analysis expression in one of my straight table. I'm looking for an equivalent expression in load script.

sum({<Date-={'""'}>}Sales).

Can someone help me on this please.

Regards,

Vikas

2 Replies
Vegar
MVP
MVP

Load 

If (Date <> '""',Sales) as CalcSales,

Sales as Sales,

Date as Date

From...

Colin-Albert
Partner - Champion
Partner - Champion

If your date field is held correctly as a dual or numeric value, then this will work

Load 
If (Date > 0, Sales) as CalcSales,
Sales,
Date 
From xxxxx

Then in your chart use    sum(CalcSales)

I'm not sure why you would have Sales data with nul or empty dates though.