Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
I am trying to integrate a set analysis expression in to my dashboard that tells me the % complete for each lot i.e. counting the number of authorised samples / total number of samples
=count(RESULT_STATUS='A')/count(TOTAL(Sample_Name))
I want the % complete to still be accurate regardless if user filters for a different result status (C or V)
Anyone have any ideas? Thanks!
count( { < RESULT_STATUS = {'A'} > } FieldYouWantToCount)
Is the syntax for the Set Analysis for your Result status field. "FieldYouWantToCount" is just a placeholder for the real field name you have that you want to count. I've also attached a Set Analysis Hands on Workshop I created if you begin working with other cases where you need it.
@qlikfresh can you share a sample data and the expected output ?
count( { < RESULT_STATUS = {'A'} > } FieldYouWantToCount)
Is the syntax for the Set Analysis for your Result status field. "FieldYouWantToCount" is just a placeholder for the real field name you have that you want to count. I've also attached a Set Analysis Hands on Workshop I created if you begin working with other cases where you need it.
Thanks @Dalton_Ruer ! That PDF is really handy will be making use of it