Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

fredericvillemi
Contributor III

Problem with Set Analysis and variable

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Problem with Set Analysis and variable

hi,

maybe u can try something like this:

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

C u,

Stefano.

2 Replies
lironbaram
Honored Contributor II

Re: Problem with Set Analysis and variable

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

Not applicable

Re: Problem with Set Analysis and variable

hi,

maybe u can try something like this:

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

C u,

Stefano.

Community Browser