topic set analysis with variable in QlikView

set analysis with variable

Fri, 09 Oct 2009 16:19:16 GMT

Hi,

The set analysis A is working correct.

I would like the same formel with variable as B1

The set analysis B2 isn't working correct. It come the value 0.

Can anybody help me for set analysis B2, why is wrongs.

A)Sum({$<[Calendar.Month]=, Calendar.Year=> * 1<[Calendar.MonthYear]=

{"$(='<='&Only(date(addmonths([Calendar.MonthYear],-1),'MMM-YYYY'))&'>'&Only(date(addmonths([Calendar.MonthYear],-13),'MMM-YYYY')))"} >}

Sales)

B1)

Varstartdate =(date(addmonths([Calendar.MonthYear],-1),'MMM-YYYY' ))

VarEnddate =(date(addmonths([Calendar.MonthYear],-13),'MMM-YYYY' ))

Varstartdate and VarEnddate display correct date.

B2)

sum({$<[Calendar.Month]=, Calendar.Year => * 1<[Calendar.MonthYear]=

{'>=$Only(#Varstartdate) <= $Only(#VarEnddate)'} >} Sales)

Thanks

Anonymous — Fri, 09 Oct 2009 16:44:28 GMT

Hi,

Without seeing the data it is hard to say..... try double quotes around your variables part, not single ones......

sum({$<[Calendar.Month]=, Calendar.Year => * 1<[Calendar.MonthYear]=

{">=$Only(#Varstartdate) <= $Only(#VarEnddate)"} >} Sales)

Fri, 09 Oct 2009 17:16:16 GMT

Hi,

Thanks for your Help.

it doesen't work.

attached qvw

Thanks