topic Looking for equivalent expression of set analysis in load script in QlikView

Looking for equivalent expression of set analysis in load script

vikasshana — Wed, 16 Mar 2022 16:20:33 GMT

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

Vegar — Wed, 16 Mar 2022 21:40:30 GMT

Load

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

Sales as Sales,

Date as Date

From...

Colin-Albert — Thu, 17 Mar 2022 11:52:08 GMT

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.