Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

CountIFS

Hei

i have the following data som i want in Qlick view

 

Sales DocumentTypeDeliveryBilags numberIs OK
50004613*Webordre81931268 OK
50013535*Webordre82121860 OK
50013969*Webordre   
50017382*Webordre   
50018796*Webordre 5105602763OK
50018796*Webordre 5105602763OK
50019063*Webordre   
50021005*Webordre   
50021647*Webordre   
50022977*Webordre   
50023571*Webordre 5105610647OK
50023571*Webordre   
50023571*Webordre 5105610647OK
50023571*Webordre 5105610647OK
50023571*Webordre 5105610647OK
50023571*Webordre 5105610647OK
50024017*Webordre   
50024017*Webordre   
50024959*Webordre   
50024959*Webordre 5105617763OK
50025267*Webordre   
50025267*Webordre 5105616551OK
50025267*Webordre 5105616551OK
50025267*Webordre 5105617473OK

 

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, )

Labels (2)
1 Reply
Highlighted
Contributor
Contributor

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)