topic Re: CASE STATEMENT IN SQL TO QLIKVIEW in QlikView

CASE STATEMENT IN SQL TO QLIKVIEW

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

Hi,

Can anyone help me to write this statement in Qlikview

Sample Data:

WEEK COUNT

1 75000

2 39000

3 4000

4 2600

5 1400

6 900

7 300

8 68

9 2

10 1

11 100

12 5

SO I NEED TO CREATE A BUCKET...!

REQUIRED OUTPUT

WEEK COUNT

1 75000

2 39000

3-12 9376 (which is sum of all the other weeks except 1,2)

SQL CODE: TO GET THE ABOVE SAID OUTPUT

CASE

WHEN WEEK IN (1,2) THEN

COUNT(WEEK) /WEEK

ELSE SUM(WEEK) END AS COULMN_NAME

IS THERE A WAY TO RESOLVE THIS ISSUE...??

THANKS IN ADVANCE..

Re: CASE STATEMENT IN SQL TO QLIKVIEW

sunny_talwar — Fri, 12 May 2017 23:02:55 GMT

Dimension

LOAD Week,

Count,

If(WEEK > 3, Dual('3-12', 3), WEEK) as Bucket

FROM ....

and not use Bucket as dimension and Sum(Count) as Expression

Re: CASE STATEMENT IN SQL TO QLIKVIEW

Sat, 13 May 2017 10:02:29 GMT

Dimension ->week

Expression->if(WEEK=1 ,Sum (COUNT),if(WEEK=2 ,Sum (COUNT),Sum({<WEEK-={1,2}>}total COUNT)))

Re: CASE STATEMENT IN SQL TO QLIKVIEW

SK28 — Tue, 16 May 2017 13:07:03 GMT

Thank You

Re: CASE STATEMENT IN SQL TO QLIKVIEW

shiveshsingh — Tue, 16 May 2017 17:56:00 GMT

WEEK -={1,2}

Can u try by making above expression variable?

Re: CASE STATEMENT IN SQL TO QLIKVIEW

tyagishaila — Wed, 17 May 2017 06:58:27 GMT

If(WEEK > 3, Dual('3-12', 3), WEEK) as Bucket

What is the use of Dual over here?