Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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, )
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)