Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

helen_pip
Contributor II

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

Re: Concatenate in a pivot table remains same value

Try smthg like this:

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

helen_pip
Contributor II

Re: Concatenate in a pivot table remains same value

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

Community Browser