topic Re: Get in QlikView

Get

Wed, 07 Jan 2015 15:29:01 GMT

I'm trying to use the enddate of a period decided by Year and Month selections on two listboxes (standard representation of master calendar) , and using this value to find the sales on this last date, using set analysis.

So the flow of execution is planned to be like the following:

The user select a period
This triggers qlik to calculate the variable vL.MaxSelectedDate (date (max( AppDate ) )
Then this variable should be sent back to calculate the sales on this particular date, by using set analysis. Se the formula below:

sum (
   {$<
         AppDate = { $(=vL.MaxSelectedDate) }
   > }
   Sales
)

See the attached application for all details.

Any suggestions on how this can be solved, or if it is at all possible to solve.

Re: Get

rwunderlich — Wed, 07 Jan 2015 16:03:06 GMT

1. Add an "=" to your variable def of vL.MaxSelectedDate. ie

=date (max( AppDate ))

2. Add single quotes to your set expression.

sum (

{$<

AppDate = { '$(=vL.MaxSelectedDate)' }

> }

Sales

)

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Get

MarcoWedel — Wed, 07 Jan 2015 16:11:51 GMT

you don't have to use variables in this case:

=Sum({$<AppDate={'$(=max(AppDate))'}>} Sales)

could work as well.

hope this helps

regards

Marco

Re: Get

Thu, 08 Jan 2015 11:09:28 GMT

Thanks Marco,

I could not get this work right away so I put it away since I want to use variables and Rob's suggestion works.

Your suggestion took away the errormessage, so I could probably get it working if I started looking into it but since I have a working solution I will not pursue that right now.

Re: Get

MarcoWedel — Thu, 08 Jan 2015 13:29:14 GMT

OK.

Thanks for your reply

Regards

Marco