topic Re: Histogram with value intervals as dimension. in QlikView

Histogram with value intervals as dimension.

marunio007 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have the following fact table:

VisitDate, Patient, KFRE

KFRE is a numerical value between 0 and1.

I was able to create a nice simple histogram where chart dimension is =Round(KFRE, 0.025) and expression is =Count(Patient) .

This gives me the number of visits with KFRE values within each KFRE interval for all the visits.

Since a patient can have more than 1 visit I need such histogram but only for the last patient's visit.

The expression would be something like this:

=Count({<VisitDate={$(=Max(VisitDate))}>}Patient)

but I am not getting any values on output.

What am I doing wrong?

Re: Histogram with value intervals as dimension.

devarasu07 — Mon, 27 Mar 2017 18:42:13 GMT

Hi,

Try like below,

=Count({<VisitDate={'$(=Max(VisitDate))'} >} Patient)

if it's not working, can you share your sample app with mock data. tks

also check this

Histogram example

Recipe for a Histogram

Regards,

Deva

Re: Histogram with value intervals as dimension.

marunio007 — Mon, 27 Mar 2017 18:50:37 GMT

Thank you for your reply, but same result - no values on the output.

Re: Histogram with value intervals as dimension.

sunny_talwar — Mon, 27 Mar 2017 18:59:18 GMT

May be this:

FirstSortedValue(Aggr(Count(Patient), VisitDate, Patient), -Aggr(VisitDate, VisitDate, Patient))

Re: Histogram with value intervals as dimension.

marunio007 — Mon, 27 Mar 2017 19:55:15 GMT

Thanks Sunny, but this does not seem to work...

In the attached sample I am looking to get this:

ROUND(KFRE,0.025)	Last Visit KFRE Count
0.050	2
0.600	1

Re: Histogram with value intervals as dimension.

sunny_talwar — Tue, 28 Mar 2017 02:08:34 GMT

Try this

Dimension

=Num(Aggr(FirstSortedValue(Round(KFRE,0.025), -VisitDate), Patient), '#.000')

Expression

=Count(DISTINCT Patient)

Re: Histogram with value intervals as dimension.

marunio007 — Tue, 28 Mar 2017 13:05:24 GMT

Thank you Sunny.

This works, but it appears that Patient is now the dimension in the chart, not KFRE

When I make a selection in the chart I am selecting patients.

Is there a way to change this, so making a selection in the chart selects KFRE values?

Your help is greatly appreciated!

Re: Histogram with value intervals as dimension.

sunny_talwar — Tue, 28 Mar 2017 13:25:54 GMT

This, unfortunately won't be possible I think.... But I may be wrong and someone else might be able to assist....

Re: Histogram with value intervals as dimension.

marunio007 — Tue, 28 Mar 2017 13:28:56 GMT

Thank you so much for your help Sunny!

I'll keep on pounding at this for some time...

Re: Histogram with value intervals as dimension.

sunny_talwar — Tue, 28 Mar 2017 13:30:26 GMT

Sure....One way I can think is to add triggers, but it can become a little messy...

Re: Histogram with value intervals as dimension.

marunio007 — Thu, 30 Mar 2017 18:49:41 GMT

I have found a solution in this thread:Help with Set Analysis - MAX

The needed expression does not use set analysis:

=count(If(VisitDate=Aggr(Nodistinct Max(VisitDate),Patient),Patient))

Re: Histogram with value intervals as dimension.

sunny_talwar — Fri, 31 Mar 2017 01:02:20 GMT

Thanks for sharing.... I am sure others will benefit from this