Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am still learning the basics of QlikView and would appreciate some help.
This may not be even close to the correct syntax, but I have been unable to find (or use trial and error) the correct syntax / operators.
This is an expression from a chart object (a dial) and I am looking to add up all of the instances for the three "COUNT Scenarios" below...
=SUM(COUNT({<
STATUS={'Completed','Processed'},
TASK_TYPE={'Receipt'},
TASK_DURATION={"<=3"}
COUNT({<
STATUS={'Completed','Processed'},
TASK_TYPE={'Confirmation'},
TASK_DURATION={"<=5"}
COUNT({<
STATUS={'Completed','Processed'},
TASK_TYPE={'Order'},
TASK_DURATION={"<=1"}
>}TASK_REF)
Obviously, it doesn't work - but I can not work out how to fix it.
Any help will be appreciated !!
Thanks,
Jonathan
Hi,
Is this what you are looking for? (Counting all three possible instances of TASK_REF)
=COUNT({<
STATUS={'Completed','Processed'},
TASK_TYPE={'Receipt'},
TASK_DURATION={"<=3"}
> + <
STATUS={'Completed','Processed'},
TASK_TYPE={'Confirmation'},
TASK_DURATION={"<=5"}
> + <
STATUS={'Completed','Processed'},
TASK_TYPE={'Order'},
TASK_DURATION={"<=1"}
>} TASK_REF)
Hope that helps.
Miguel
Hi,
Is this what you are looking for? (Counting all three possible instances of TASK_REF)
=COUNT({<
STATUS={'Completed','Processed'},
TASK_TYPE={'Receipt'},
TASK_DURATION={"<=3"}
> + <
STATUS={'Completed','Processed'},
TASK_TYPE={'Confirmation'},
TASK_DURATION={"<=5"}
> + <
STATUS={'Completed','Processed'},
TASK_TYPE={'Order'},
TASK_DURATION={"<=1"}
>} TASK_REF)
Hope that helps.
Miguel
Hi,
Did you expected this result?
COUNT({<
STATUS={'Completed','Processed'},
TASK_TYPE={'Receipt','
},Confirmation
','Order'
TASK_DURATION={"<=5"} TASK_REF)
Celambarasan
Miguel,
That is great, thank you - exactly what I was looking for.
It does however highlight something else that I must now learn.
As you may have guessed, I am calculating SLA performance metrics.
I have used your suggestion as follows:
=COUNT({<
STATUS={'Completed','Processed'},
TASK_TYPE={'Receipt'},
TASK_DURATION={"<=3"}
> + <
STATUS={'Completed','Processed'},
TASK_TYPE={'Confirmation'},
TASK_DURATION={"<=5"}
> + <
STATUS={'Completed','Processed'},
TASK_TYPE={'Order'},
TASK_DURATION={"<=1"}
>} TASK_REF)
/
COUNT({<
STATUS={'Completed','Processed'},
TASK_TYPE={'Receipt','Confirmation','Order'}
>} TASK_REF)
It now says "No data to display" - my guess is because we have not yet had any instances of "Confirmation" or "Order".
Is there an easy fix?
Many thanks
Jonathan
Miguel,
That is great, thank you - exactly what I was looking for.
It does however highlight something else that I must now learn.
As you may have guessed, I am calculating SLA performance metrics.
I have used your suggestion as follows:
=COUNT({<
STATUS={'Completed','Processed'},
TASK_TYPE={'Receipt'},
TASK_DURATION={"<=3"}
> + <
STATUS={'Completed','Processed'},
TASK_TYPE={'Confirmation'},
TASK_DURATION={"<=5"}
> + <
STATUS={'Completed','Processed'},
TASK_TYPE={'Order'},
TASK_DURATION={"<=1"}
>} TASK_REF)
/
COUNT({<
STATUS={'Completed','Processed'},
TASK_TYPE={'Receipt','Confirmation','Order'}
>} TASK_REF)
It now says "No data to display" - my guess is because we have not yet had any instances of "Confirmation" or "Order".
Is there an easy fix?
Many thanks
Jonathan
Hi Jonathan,
If you try both COUNT() in different text objects, for example, do you get any result for both? Do you have any selection done when showing the chart?
Hope that helps.
Miguel
Miguel,
Thank you - after much digging into detail, it is now working.
It seems that it may have been the QlikView equivalent of an Excel #DIV/0 error.
All working, and I have learnt some new syntax.
Thanks for your help...
Jonathan
Miguel,
Thank you - after much digging into detail, it is now working.
It seems that it may have been the QlikView equivalent of an Excel #DIV/0 error.
All working, and I have learnt some new syntax.
Thanks for your help...
Jonathan