Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
10639138
Contributor
Contributor

Discontinue selling the products that has not been selling enough for the past 2 years

 
1 Reply
kaushiknsolanki

Hi,

You can simply create a days difference between OrderDate and Today, and use simple condition to identify the products which should be stopped.

For example.

Data:

Load *,Today() - OrderDate as Diff from XYZ;

Final:

Load *,If(Diff>365,'Discontinue','Continue') as Flag Resident Data;

 

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".