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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Re: Create new variable in load script with OR

Thank you Sunil!

But I do not understand your syntax.

Did you mean like this?

Load

Time,

Client_ID,

if(sum(Happy_client)>0,1) as Good_time,Good time Good timeGood time

from path

group by  Time ,Client_ID;

Sounds good, but I would like to use no "if", because this makes everything very slow. So I use an "OR".

1-product(1-Happy_client)

But how is the function for Products called?

0 Replies