topic Re: Set Analysis not working with a date Set Modifier in QlikView

Set Analysis not working with a date Set Modifier

Fri, 03 May 2013 20:45:31 GMT

Want to limit budget information to the most recent selected date and third level of the budget.

Expression is in a chart. When the BudgetDate set modifier is added to the expression, the chart says 'No Data to Display'.

The expression works without the BudgetDate set modifier. Displaying Max(BudgetDate) in a text object shows the expected date. The syntax seems correct. I'm stumped. Hints or suggestions are most appreciated.

SUM( {$ <    BudgetDate = { $ ( #=Max(BudgetDate) ) },
                   BudgetLevel = {'3'}
        > } [Available])

Re: Set Analysis not working with a date Set Modifier

MayilVahanan — Fri, 03 May 2013 21:23:09 GMT

Try like this

=Sum({<BudgetDate = { ' $(=Max(BudgetDate))'},BudgetLevel = {'3'}>}Available)

Regards,

R.Mayil Vahanan

Re: Set Analysis not working with a date Set Modifier

Mon, 06 May 2013 16:10:04 GMT

That did not solve the issue. I've attached a small example -- Chart with the issue is the one on the left.

Re: Set Analysis not working with a date Set Modifier

swuehl — Mon, 06 May 2013 17:13:34 GMT

Just remove a space in your BudgetDate field modifier (the one after the first single quote):

=Sum({< BudgetDate = { '$(=Max(BudgetDate))'}, BudgetLevel = {'3'} >} Available)