set analysis yearweek is not working properly

[ravindraa]

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).

[PrashantSangle]

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,

[aveeeeeee7en · Accepted solution]

Hi

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

[ravindraa]

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,

[ravindraa]

Hi Maxdreamer

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