topic Re: Below & above in QlikView

Below & above

sagaraperera — Thu, 01 Oct 2015 09:07:39 GMT

Dear All,

i want to below 100000 and above 100000 sales figure separately, and it is name should be AGE. my script given below.in this script GROSSTOT is a value colum.

SALES:

LOAD BCOD,

CLA_CODE,

PRD_CODE,

POLICY_NO,

REF_NO,

DATE(floor(MARKETING_DATE)) as MARKETING_DATE,

//DATE(monthstart(MARKETING_DATE), 'MM-YYYY') as MonthYear,

MDATE,

YEAR,

MONTH,

NAME,

ME_CODE,

//TRN_DATE,

DATE(floor(TRN_DATE)) as TRN_DATE,

TRAN_YEAR,

TRAN_MONTH,

POL_PERIOD_FROM,

SCCOD,

IF(SCCOD>='SC0','COUNTER')AS CITY_COUNTER,

CP,

RS,

TC,

GROSSTOT,

TYPE,

N_R_NOS1,

F_NOS2

FROM

G:\qlickviwe\Sales\SALES2012.QVD

(qvd);

Re: Below & above

SreeniJD — Thu, 01 Oct 2015 09:29:17 GMT

Hi Sanka

Can you please provide some more clarity on your question

Thanks,Sreeni

Re: Below & above

sagaraperera — Thu, 01 Oct 2015 09:33:07 GMT

I want to sales figure in a separately it should be is below 10000 & above 100000 base on Grostot.

thanks

Re: Below & above

krishna20 — Thu, 01 Oct 2015 10:12:32 GMT

Hi ,

Your Script may be like this,

SALES:

LOAD *,

if(Sum(GROSSTOT)<100000 ,GROSSTOT) as AGE;

LOAD *,

if(Sum(GROSSTOT)>100000, GROSSTOT) as GROSS_AGE;

LOAD BCOD,

CLA_CODE,

PRD_CODE,

POLICY_NO,

REF_NO,

DATE(floor(MARKETING_DATE)) as MARKETING_DATE,

//DATE(monthstart(MARKETING_DATE), 'MM-YYYY') as MonthYear,

MDATE,

YEAR,

MONTH,

NAME,

ME_CODE,

//TRN_DATE,

DATE(floor(TRN_DATE)) as TRN_DATE,

TRAN_YEAR,

TRAN_MONTH,

POL_PERIOD_FROM,

SCCOD,

IF(SCCOD>='SC0','COUNTER')AS CITY_COUNTER,

CP,

RS,

TC,

GROSSTOT,

TYPE,

N_R_NOS1,

F_NOS2

FROM

G:\qlickviwe\Sales\SALES2012.QVD

(qvd);

Re: Below & above

gautik92 — Thu, 01 Oct 2015 10:15:29 GMT

if(Sum(GROSSTOT)<100000 ,GROSSTOT) as age,

if(Sum(GROSSTOT)>100000 ,GROSSTOT) as age,

Re: Below & above

MarcoWedel — Tue, 20 Oct 2015 21:28:48 GMT

Hi,

please don't post the same questions multiple times and try to close your threads if you received correct answers.

Below 100,000 & Above 100,000

below above

Below & above

thanks

regards

Marco