topic Set analysis question in QlikView

Set analysis question

Tue, 23 Sep 2014 18:59:04 GMT

Hi ,I am stuck with a set analysis syntax

Now there is a field Daynumber which has data as

and there is a field named ComFlag which has Y and N as values

Now i want to select the max day number which has flag set to Y,

I am trying to do something like

=Max( { <[ComFlag]='Y'>} Daynumber)

But I am getting an error,any idea why ?

thanks for your help

Anonymous — Tue, 23 Sep 2014 19:01:54 GMT

try this

=Max( { <[ComFlag]={'Y'}>} Daynumber)

Anonymous — Tue, 23 Sep 2014 19:41:33 GMT

Max( { <[ComFlag]={'Y'}>} Daynumber) .. curly braces is missing in your syntaxx

Tue, 23 Sep 2014 19:57:38 GMT

TY...

Tue, 23 Sep 2014 19:57:46 GMT

Tue, 23 Sep 2014 20:37:14 GMT

If i have an expression (Actuals/Total)*Forecast and i want to use the date 10 days after the above date.any idea how to modify the equation??

Anonymous — Tue, 23 Sep 2014 20:43:59 GMT

cna you post the qvw file with some sample data i can be able to help you .

Tue, 23 Sep 2014 21:20:24 GMT

I got it i used =max({<Day_number_in_month={$(=Max( { <[Completed]={'Y'}>} Daynumber) + 10)}>}((Actuals/Total)*Forecast))

Anonymous — Tue, 23 Sep 2014 21:28:26 GMT

glad you got it.. Sorry tied up with work. i could not get to you...