Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

2 Replies
qlikview979
Specialist
Specialist

Kushal_Chawda

try this

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