Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

A unique problem with the measures

I have a chart which displays both the sales and the budget figures. What I want to do here is if a particular date is selected then the sales should change but the budget figures shouldn't change. I can't achieve this using the following set analysis expression.

//Sum({<DateID=>}BudgetValue)

I have attached the file. Can you kindly help?

Regardless of whether a sale has happened or not the budget value set should still come out in the chart. That is the requirement.

Thanks,

Ram

2 Replies
Sokkorn
Honored Contributor

Re: A unique problem with the measures

Hi Ramkumar,

I try your set analysis and it working fine Sum({<DateID=>}BudgetValue). Please check it again.

Regards,

Sokkorn

MVP
MVP

Re: A unique problem with the measures

Hi Ram,

This expression is working, even if you select DateID, the budget won't change because we are excluding the selections.  Please come up with example if not clear 

=Sum({<DateID=>}BudgetValue)

Regards,

Jagan.

Community Browser