Counting orders with zero costs weekly

[Anonymous]

Hi all,

I'am new to this site and qlikview.
Bud i have the following question and i hope there is someone on line to help me:

I have the following dimentions in qlikview:

1 Timestamp_loaded (weekly upload orders)

2 Order

3 System_status

4 TotCostAct

I'am building a dashboard and i want to get the orders that are TECO (=System_status)  with zero costs weekly.

Can any one help me with this?

=count({$<System_status=('TECO'

gr. Patrick Vos

[qlikview979]

Hi everyone,

[Kushal_Chawda]

try this

count({$<System_status={'TECO'},TotCostAct={0}>} Order)