Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

sachinnataraj
New Contributor II

Sum two filters or more

Hello,

In KPI I am trying to sum two or more filters which are in same column.

Sum({$<[ product type]={"FIX"}>} and {$<[ product type]={"FIX"}>}[Count Shipment]) [this gives an error]


Sum({$<[product type]={"FIX"},[product type]={"TIME_WINDOW"}>}[Count Shipment]) [this only reads the last one (TIME_WINDOW)]


Can you please help me with this.


Thank you & Regards,


Sachin

1 Solution

Accepted Solutions
jwjackso
Contributor III

Re: Sum two filters or more

Try Sum({$<[product type]={'FIX','TIME_WINDOW'}>} [Count Shipment])

1 Reply
jwjackso
Contributor III

Re: Sum two filters or more

Try Sum({$<[product type]={'FIX','TIME_WINDOW'}>} [Count Shipment])