topic Re: Concatenate in a pivot table remains same value in QlikView

Concatenate in a pivot table remains same value

helen_pip — Thu, 01 Nov 2012 15:56:29 GMT

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

Re: Concatenate in a pivot table remains same value

Thu, 01 Nov 2012 16:09:17 GMT

Try smthg like this:

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

Re: Concatenate in a pivot table remains same value

helen_pip — Tue, 06 Nov 2012 10:17:34 GMT

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