topic Re: Problem with Set Analysis and variable in QlikView

Problem with Set Analysis and variable

fredericvillemi — Thu, 08 Sep 2011 08:16:41 GMT

Hi,

i have a variable called "onemonth"

=if (text(STARTDAY) > Date(NOW()-30,'YYYYMMDD'),'Yes','No')

i have a graph with STARTDAY as dimension and i want to show only the 30 last days using onemonth variable = 'Yes'

I have created this set analysis expression :

=sum({$<$(onemonth) = {'Yes'} >} PHY_READ_BYTES)

but it shows all days with good data.. If i switch Yes to No in the set analysis, it's exactly the same..

what is missing in my set analysis ??

Thanks

lironbaram — Thu, 08 Sep 2011 08:58:27 GMT

hei

attach is an example

may be you can use it

in the input box you can change the number of the days you want to show

Thu, 08 Sep 2011 19:01:53 GMT

hi,

maybe u can try something like this:

=sum({$<STARTDAY= {"=text(STARTDAY) > Date(NOW()-30,'YYYYMMDD')"} >} PHY_READ_BYTES)

C u,

Stefano.