Count values of calculation results

siobhancrossen — Mon, 21 May 2018 15:53:42 GMT

I am trying to create a text box with a count of records which meet certain criteria, but I'm having problems getting the syntax to work. I have 2 tables in my load script (OrderA and OrderB) and within my app I have the below calculated dimension, which utilizes fields from both:

=if((OrderATime-OrderBTime) > 0, 'No',

if((OrderACancelTime-OrderBTime) < 0, 'No',

if((OrderACancelTime-OrderBCompletionTime) < 0, 'No', 'Yes')))

What I want to do is have a text box which counts the number of 'Yes' records - at the moment the above just provides a null ('-') in the text box, however I know that there should be a value of '1' shown

Any help would be hugely appreciated!

Many thanks

Re: Count values of calculation results

sunny_talwar — Tue, 29 May 2018 16:30:56 GMT

May be this

=Sum(

if((OrderATime-OrderBTime) > 0, 0,

if((OrderACancelTime-OrderBTime) < 0, 0,

if((OrderACancelTime-OrderBCompletionTime) < 0, 0, 1)))

)

topic Count values of calculation results in QlikView

Count values of calculation results

Re: Count values of calculation results