topic Re: Set analysis not working after data model change in QlikView

Set analysis not working after data model change

Wed, 26 Mar 2014 09:30:54 GMT

Hi,

I've changed my date format in the script from 'YYYYMM' to 'MM/YYYY'.

Now my set analysis is broken, at least it does not show anything:

sum({$<Abschlusstermin.P= {">=$(=date('$(vFYStart)'))<=$(=date('$(vToday)'))"}>} Value)

Content of vFYStart is '01.04.2013', vFYEnd is '31.03.2014'

How do I have to change the expression to let it work again?

Thanks.

MK_QSL — Wed, 26 Mar 2014 09:33:55 GMT

sum({$<Abschlusstermin.P= {">=$(=date('$(vFYStart)'),'MM/YYYY')<=$(=date('$(vToday)'),'MM/YYYY')"}>} Value)

PrashantSangle — Wed, 26 Mar 2014 09:34:08 GMT

Hi,

What is format of Abschlusstermin.P this field???

Regards

Wed, 26 Mar 2014 09:38:15 GMT

'MM/YYYY'

PrashantSangle — Wed, 26 Mar 2014 09:43:25 GMT

Hi,

Then try manishkachhia expression ,It should work

Or You can also do one thing save vFYStart and vToday variable in that format .

Then it should Work

If Still not worked then Use

Date(Date#(vFYStart,'DD.MM.YYYY'),''MM/YYYY) and

Date(Date#(vToday,'DD.MM.YYYY'),''MM/YYYY) in above expression

Regards,

SunilChauhan — Wed, 26 Mar 2014 09:43:39 GMT

make vFyStart and Vtoday variable in same format