topic Re: set analysis yearweek is not working properly in QlikView

set analysis yearweek is not working properly

ravindraa — Sat, 02 Aug 2014 11:01:22 GMT

Hi all,

i have one requirment that we need to display the sales QTY by yearweek wise.

my YEAR WEEK field existed like below.

YEAR WEEK salesqty

2014-01 10

2014-02 20

2014-04 30

2014-11 40

2014-17 50

2014-21 60

my requiermentt is we need to display the sales qty data greter than 2014-11(yearweek).

i have wrote one expresion but is doesn't display any value please give me any suggesion.

my expression1::: sum({<yearweek={'>2014--11'}>}salesqty).

Re: set analysis yearweek is not working properly

PrashantSangle — Sat, 02 Aug 2014 11:21:46 GMT

Hi,

I am Considering YearWeek as your dimension.

Then instead of trying set analysis,

You can try in dimension only

Write in dimension

=if([YEAR WEEK]>'2014-11',[YEAR WEEK])

and also check supress when value is null in dimension tab.

Regards,

Re: set analysis yearweek is not working properly

aveeeeeee7en — Sat, 02 Aug 2014 11:35:21 GMT

First Make YEARNUM field as Number in the Backend Script.

Like this

Load *, replace(YEARWEEK,'-','') AS YEARWEEKNUM INLINE [

YEARWEEK, salesqty

2014-01, 10

2014-02, 20

2014-04, 30

2014-11, 40

2014-17, 50

2014-21, 60

];

Than Use it in the Expression. See this:

SUM({<YEARWEEKNUM = {"=YEARWEEKNUM>201411"} >} salesqty)

Also, See the Attachment.

Regards

Aviral Nag

Re: set analysis yearweek is not working properly

ravindraa — Sun, 03 Aug 2014 11:41:44 GMT

Hi Nag Avirl

thank you very much for reply and given the correct answer.

if any chance to get the answer without change the yearweek as number field, lf you have suggestion please give me.

any way i am getting values.

thank you very much,

Re: set analysis yearweek is not working properly

ravindraa — Sun, 03 Aug 2014 11:43:00 GMT

Hi Maxdreamer

thank you very much for reply and given the correct answer.