topic Why This set analysis not work? in QlikView

Why This set analysis not work?

Anonymous — Thu, 13 Oct 2011 07:46:52 GMT

Hi all,

I post the sample where my set analysis not work ..

Thank to all

Andrea

Re: Why This set analysis not work?

Thu, 13 Oct 2011 08:19:35 GMT

Set analysis may not work > operataors when you use the format option. Attached one of the ways to solved the your problem.

Hope it helps,

Kiran.

Re: Why This set analysis not work?

IAMDV — Thu, 13 Oct 2011 08:22:51 GMT

Hi Andrea,

Have you tried to use this expression?

Sum({<YearMonth = {">=$(=Date(addmonths(Max(YearMonth), -12), 'MMM YY')) <=$(=Date(addmonths(Max(YearMonth), 0), 'MMM YY'))"} >} Sales)

I guess its the formating issue. I hope this helps!

Cheers - DV

Why This set analysis not work?

Anonymous — Thu, 13 Oct 2011 08:30:18 GMT

Thank Kiran for your answer

unfortunately is not wath i want because if u select a month i can not see 12 month before.

Thank

Why This set analysis not work?

Thu, 13 Oct 2011 08:32:55 GMT

You this expression:

Sum({<YearMonthID ={">$(=Max(YearMonthID)-12)"},YearMonthName= >} Sales)

kiran

Re: Why This set analysis not work?

Thu, 13 Oct 2011 08:33:07 GMT

You this expression:

Sum({<YearMonthID ={">$(=Max(YearMonthID)-12)"},YearMonthName= >} Sales)

kiran

Why This set analysis not work?

Anonymous — Thu, 13 Oct 2011 08:33:32 GMT

Ciao DV,

thank u are right now it works...

Thank very much

Andrea

Re: Why This set analysis not work?

SunilChauhan — Thu, 13 Oct 2011 08:33:38 GMT

see the attached file and put your data and change thee dimension andd expression accordingly

hope this helps

Why This set analysis not work?

Anonymous — Thu, 13 Oct 2011 08:40:29 GMT

Thank kiran , try wath DV send me is that wath i wanted.

Thank for your help

Andrea

Why This set analysis not work?

Anonymous — Thu, 13 Oct 2011 08:41:13 GMT

Thank Sunil your attch is very helpfull

Re: Why This set analysis not work?

IAMDV — Thu, 13 Oct 2011 08:57:25 GMT

Andrea - You are welcome. I am glad it works for you.

I am attaching a Demo App for Point In Time Reporting. Please be aware that I have not created this App. I have picked up from community and using this as reference.

Cheers - DV

Why This set analysis not work?

Miguel_Angel_Baeyens — Thu, 13 Oct 2011 09:03:46 GMT

Hi Andrea,

It doesn't work because there cannot be ranges using literals, in your case 'dic-10' is a string (although returned by a Date()) function) and dealt as such as a literal (so the order is not >= or <=) To solve this, create a Date field in your script, using MakeDate(Year, Month) for example (it will return the first day of each month) and use this field in the set analysis instead of the year month field.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Why This set analysis not work?

Anonymous — Thu, 13 Oct 2011 09:05:08 GMT

DV ,

Thank very much for sharing .. is veru useful

Ciao

Andrea

Why This set analysis not work?

Anonymous — Thu, 13 Oct 2011 09:11:08 GMT

Ciao Miguel,

thank for your answer.

The problem was a the formating issue like DV said.

If u get my projet i have post , and put set analysys DV wrote it's works

Ciao Miguel and thank