CountIFS

[mumer_88]

Hei

i have the following data som i want in Qlick view

Sales Document	Type	Delivery	Bilags number	Is OK
50004613	*Webordre	81931268		OK
50013535	*Webordre	82121860		OK
50013969	*Webordre
50017382	*Webordre
50018796	*Webordre		5105602763	OK
50018796	*Webordre		5105602763	OK
50019063	*Webordre
50021005	*Webordre
50021647	*Webordre
50022977	*Webordre
50023571	*Webordre		5105610647	OK
50023571	*Webordre
50023571	*Webordre		5105610647	OK
50023571	*Webordre		5105610647	OK
50023571	*Webordre		5105610647	OK
50023571	*Webordre		5105610647	OK
50024017	*Webordre
50024017	*Webordre
50024959	*Webordre
50024959	*Webordre		5105617763	OK
50025267	*Webordre
50025267	*Webordre		5105616551	OK
50025267	*Webordre		5105616551	OK
50025267	*Webordre		5105617473	OK

i have use the countifS in the cloumn"Is OK" the conditions i used was,

1. First of all alle orders that has order type "*Webordre"
2. No. of Count in the column "sales document" per order = No. of Count in the column "Bilags number"
3. in addition if there is value in the Column "Delivery" that is also "Is OK" although this has no values in the column "Bilags number"

the commands i used in Excel was

• =COUNTIFS(V:V;V2)
• =COUNTIFS(V:V;V2;BH:BH;"OK")
=BE:BE-BF:BF (should only filter about the values if the difference is 0, )

[mumer_88]

i am using this statement but it says error in statement

If(Count(TOTAL <Sales document>Sales document) = sum({Count(TOTAL <Bilags number>Bilags number)}),1)