topic Re: set analysis upper than. in QlikView

set analysis upper than.

Tue, 10 Jul 2012 17:45:52 GMT

Hi,

I try to create a set analysis with a set modifier wheer Num is over than 2000

<Num= {2000}> it's working

<Num> {2000}> it's not working

someone has got an idea about the syntax?

Eva

Re: set analysis upper than.

nagaiank — Tue, 10 Jul 2012 17:48:55 GMT

Try

<Num={">2000"}>

Re: set analysis upper than.

MayilVahanan — Tue, 10 Jul 2012 17:55:54 GMT

Try this,

<Num={">2000"}> instead of <Num> {2000}> because in this, <Num> scope finish here itself..

Hope it helps

Re: set analysis upper than.

Tue, 10 Jul 2012 18:01:29 GMT

Hi Thanks for yours answer. Is it working withText

Re: set analysis upper than.

MayilVahanan — Tue, 10 Jul 2012 18:05:45 GMT

Hi,

For number only is working . for text also its work like

<Name = {"m*"}> gives starts with m names like micheal.

Hope it helps

Re: set analysis upper than.

Tue, 10 Jul 2012 18:07:47 GMT

ok, Sorry I tried to simplify it .

I need to do set analysis whn [Fiscal Year Month] sur after [Current Fiscal Year Month]

the format is 2013/004

So I started by a value like :

= sum({<[Fiscal Year-Month] ={">2013/004"}>}metric)

but it's not working neither.

Re: set analysis upper than.

MayilVahanan — Tue, 10 Jul 2012 18:13:52 GMT

Hi,

Check the format once, both are in same format??

i.e. year/month ?? 2013/004 -> it represents ?

verify year month and current fiscal year month are in same date format . if not same means, give the same format ..

Hope it helps

Re: set analysis upper than.

Tue, 10 Jul 2012 18:15:49 GMT

no it's the same format when I did

= sum({<[Fiscal Year-Month] ={"2013/004"}>}metric) it's working

= sum({<[Fiscal Year-Month] ={">2013/004"}>}metric) it's not

thanks for your help

Re: set analysis upper than.

MayilVahanan — Tue, 10 Jul 2012 18:28:39 GMT

Hi,

Can you post sample file. Its helps to find it.. Check once, is there value for metric above that 2013/004 ? For my sample, it gives the value correctly..

Re: set analysis upper than.

Tue, 10 Jul 2012 18:53:04 GMT

Try Like this ..

Creare one more field with

Fiscal Year- Month as Num( Fiscal Year- Month ) as Fiscal Year_MonthNum in back end ..

and create a variable with num(month ( today()) as Test and then

= sum({<[Fiscal Year_MonthNum] ={">$(Test)"}>}metric)

Now we are comparing two number fields so this should work.