Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

patrickvos
New Contributor II

Counting orders with zero costs weekly

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

Tags (1)
2 Replies
qlikview979
Valued Contributor

Re: Counting orders with zero costs weekly

Re: Counting orders with zero costs weekly

try this

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

Community Browser