Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasshana
Creator II
Creator II

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

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.