topic Re: Hi everyone, in QlikView

Hi everyone,

Anonymous — Tue, 16 May 2017 06:32:59 GMT

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

Re: Hi everyone,

Anil_Babu_Samineni — Tue, 16 May 2017 09:25:06 GMT

May be this?

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

Note: Make sure to use accordingly for TotConstAct

Re: Hi everyone,

Anonymous — Tue, 16 May 2017 09:54:56 GMT

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

Re: Hi everyone,

Anil_Babu_Samineni — Tue, 16 May 2017 12:27:37 GMT

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

Re: Hi everyone,

Anonymous — Tue, 16 May 2017 13:20:59 GMT

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.

Re: Hi everyone,

Anonymous — Tue, 16 May 2017 13:28:51 GMT

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

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

Hope this helps

Re: Hi everyone,

Anonymous — Tue, 16 May 2017 14:13:16 GMT

Thx for the help.

Ive done it!

gr Patrick

Re: Hi everyone,

Anonymous — Tue, 16 May 2017 14:14:23 GMT

Excellent, glad to hear it!