topic Re: Top Two Dates in QlikView

Top Two Dates

mphekin12 — Sat, 16 Nov 2024 04:35:25 GMT

All,

I'm trying to figure out a way to show only the last two procedure stop times by primary surgeon and for an admit date in a chart (straight table or pivot) and I'm having trouble coming up with a solution. Here is what my data looks like currently:

I only want to display those rows that have the highlighted timeProcedureStop column in my final chart. The above data only shows two surgeons and one admit date, but there will be multiple surgeons and admit dates on the final chart.

Any suggestions?

Thanks for your help!

Re: Top Two Dates

vishsaggi — Fri, 01 Feb 2019 01:48:01 GMT

If you using straight table you have Dimension limits tab in chart properties where you can give largest 2 for your timeprocstop field. IF you are using pivot you might want to write and calculated dimension like

= Aggr(IF(Rank(Max(timeProcedureStip)) <=2, primarySurgeon), PrimarySurgeon)

something like this.

Re: Top Two Dates

mphekin12 — Fri, 01 Feb 2019 14:03:42 GMT

Vishsaggi, thanks for the reply but unfortunately neither of the solutions you suggested worked.

Can anyone else offer any insight?

Thank you!

Re: Top Two Dates

vishsaggi — Fri, 01 Feb 2019 14:17:21 GMT

The screen shot you attached is this a sample data ? If yes can you share this data as a text file or in a table where i can work on it.

Re: Top Two Dates

mphekin12 — Fri, 01 Feb 2019 14:48:18 GMT

Vishsaggi,

I have attached some sample data for your review. Thank you for looking at this!

Re: Top Two Dates

vishsaggi — Fri, 01 Feb 2019 18:32:14 GMT

Try this in your straight table calculated expression for dimension primary surgeon like below and check supress when value is null for this calculated dim expr.

= Aggr(IF(Rank(Max(timeProcedureStop))<=2, primarySurgeon), primarySurgeon, timeProcedureStop)