topic Re: above 1000 in QlikView

above 1000

sagaraperera — Wed, 25 Nov 2020 16:16:04 GMT

Dear All

i have a value field in GROSTOT , I want to get a value in sum of above 1000 amount

SALES:

LOAD

BCOD,

DATE(floor(MARKETING_DATE)) as MARKETING_DATE,

GROSSTOT

sagara

jmvilaplanap — Fri, 07 Jul 2017 10:18:43 GMT

Hi,

I don't understand exactly what do you want, but I'll try 😜

SALES:

LOAD

BCOD,

DATE(floor(MARKETING_DATE)) AS MARKETING_DATE,

sum(GROSSTOT) AS GROSSTOT

WHERE GROSSTOT >= 1000

GROUP BY BCOD, MARKETING_DATE;

Is this what do you need?

Regards

tresB — Fri, 07 Jul 2017 10:22:38 GMT

May be this (with preceding load)?

SALES:

Load

Where GROSSTOT>1000;

LOAD

BCOD,

DATE(floor(MARKETING_DATE)) as MARKETING_DATE,

Sum(GROSSTOT) as GROSSTOT

From <> Group By BCOD, MARKETING_DATE;

Kushal_Chawda — Fri, 07 Jul 2017 11:00:33 GMT

Or you can use the set analysis in your expression like below

=sum({<ID ={"=sum(GROSSTOT)>1000"}>}GROSSTOT)