Set Expression Syntax

[JANSHENOUDA1]

Good morning Everyone. 

I am new to Qlik Sense, and I am building a dashboard for Budget Calculations.  I am having 3 Filter Panes, and want to build a KPI for the budget and using the 3 filters to adjust the amounts. 

1st Filter Pane is using Master Calendar that I built.

2nd Filter Pane is a Patient Status

3rd Filter Pane is Facility Name.

I tried to build the KPI Set expression using this code. It is ok to choose a specific date from the Master Calendar Filter Pane, when I use any other Filter, the value immediately goes to 0.

Here is the Formula I wrote. I know it is not correct but I need help to understand it more and get it right

Sum( {$ < [Facility Name] , PtStatus > } Bvalue)

Thank You!

[rdelagarde]

Hi,

No need to get complicated with Qlik! If your KPI formula is simply : Sum(Bvalue), the value will be updated automatically according to your filters.