Hi everyone,

[Anonymous]

I'am just beginning to work with Qlik. And I have the following question. I'am trying to get the write information by connenting SAP to qlik. I want to few the orders that are technical completed with the following conditions:

1 Count order / weekly

2 Systemstatus = TECO (technical complete)

3 TotCostAct = < 0,01euro

the dimentions are:

1 Timestamp_loaded (weekly upload)

2 Order

3 Systemstatus

4 TotCostAct

Has anyone a sugestion?

=count({,System_Status=('TECO") .......?

thx for helping.

gr Patrick

[Anil_Babu_Samineni]

May be this?

Count({<Systemstatus = {'TECO'}, TotCostAct = {'<0,01euro'}>} [order / weekly])

Note: Make sure to use accordingly for TotConstAct

[Anonymous]

Anil,

It works for now thanks.

The formula used is Count({<Systemstatus = {'TECO'}, TotCostAct = {'<0,01euro'}>}

bud i have the following problem. I want to eliminate the Systemstatus REL?

Can u help me with this one?

gr Patrick

[Anil_Babu_Samineni]

Even thought When you use only for TECO it won't pick the REL. How you want to eliminate. Does it make sense?

[Anonymous]

I'am trying to build a Indicator for our Teamleader. This way he can monitor the orders (maintenance orders) that are technically closed and maintain no hour or budget. This is a serious threath to our way of working. The upload is connected to SAP and generates more orders with diverent systemstatus.

[Anonymous · Accepted solution]

Count({<Systemstatus = {'TECO'},Systemstatus-={'REL'} TotCostAct = {'<0,01euro'}>}

using -=  is the same as saying doesn't equal. You can also do <>

Hope this helps

[Anonymous]

Thx for the help.

Ive done it!

gr Patrick

[Anonymous]

Excellent, glad to hear it!