Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator III
Creator III

Concatenate in a pivot table remains same value

      

Hello

I have written the following and it returns a value of 03:06

When I add this formula to a pivot table which has month across the top, the formula remains at 03:06 for every month

=

Time(RangeFractile(.5, $(=Concat(If([Patient Admitted?]=1,[Total Wait]), ',') & ',' & Concat(If([ADMISSION_FLAG]='Y',CONCLUSION_WAIT_MINS), ','))

Could you kindly help me rewrite the formula so that it is not static and will change for every month in the pivot table

Kind Regards

Helen

2 Replies
Not applicable

Try smthg like this:

=Time(RangeFractile(.5, $(=(If([Patient Admitted?]=1,[Total Wait]) & ',') & ',' & (If([ADMISSION_FLAG]='Y',CONCLUSION_WAIT_MINS) &','))

helen_pip
Creator III
Creator III
Author

Hello

Thank you for your reply.  I have been playing with this statement for a couple of days now, and cannot seem to get it to work

The above statement unfortunatley returns a null value

Do you have any additional ideas?

Thanks

Helen