Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Set Analysis not working with a date Set Modifier

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])

1 Solution

Accepted Solutions
MVP
MVP

Re: Set Analysis not working with a date Set Modifier

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

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

3 Replies

Re: Set Analysis not working with a date Set Modifier

HI

Try like this

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

Regards,

R.Mayil Vahanan

Not applicable

Re: Set Analysis not working with a date Set Modifier

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

MVP
MVP

Re: Set Analysis not working with a date Set Modifier

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

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

Community Browser