topic Re: Two Different condition in Qlikview SQL in QlikView

Two Different condition in Qlikview SQL

Smeenakshi23 — Sat, 16 Nov 2024 01:34:02 GMT

Hello,

I am developing a Query using some requirements

in select statement i am giving Number,date,department,Type etc..Also I am summing up sum(sales) in select statement.. I need to add the below two conditions in my query. How to implement it in SQL statement.

Condition :

1) total amount(sales) with TYPE = s equals zero
2)total amount(sales) with TYPE = y is less than zero

sample code :

Select Number,sum(sales) as Total_Sales, Type, Date, Department

from ...// pulled necessary table//
where....// date condition and link fields are given here//

groupby Number,sales, Type, Date, Department;

can you please suggest.

Re: Two Different condition in Qlikview SQL

jwjackso — Wed, 08 Jan 2020 20:58:08 GMT

I think a Preceding Load statement would work.

sample code :

Load *

where (Total_Sales = 0 and TYPE = 's') or (Total_Sales < 0 and TYPE = 'y');

SQL Select Number,sum(sales) as Total_Sales, Type, Date, Department

from ...// pulled necessary table//
where....// date condition and link fields are given here//

groupby Number,sales, Type, Date, Department;

Re: Two Different condition in Qlikview SQL

Kushal_Chawda — Wed, 08 Jan 2020 21:56:28 GMT

Select a.* from (Select Number,sum(sales) as Total_Sales, Type, Date, Department from ...// pulled necessary table// where....// date condition and link fields are given here// group by Number,sales, Type, Date, Department )a Where (a.Total_Sales=0 and Type='s') or (a.Total_Sales<0 and Type='y')

Re: Two Different condition in Qlikview SQL

Smeenakshi23 — Sat, 18 Jan 2020 04:51:26 GMT

Thanks a lot