Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master
Master

Hi Ramkumar,

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

Regards,

Sokkorn

jagan
Luminary Alumni
Luminary Alumni

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.