topic Re: allow users to select distinct observations for their selection - most recent, random, etc. in QlikView

allow users to select distinct observations for their selection - most recent, random, etc.

kmstephenson — Fri, 04 Nov 2016 13:50:00 GMT

Hi All,

I'm working with healthcare data - specifically at the event (i.e. hospitalization) level. I would ideally like to make it up to the end user to decide how they want to view hospitalizations for patients with more than one hospitalization - i.e. should the dashboard show all hospitalizations, the most recent hospitalization, a randomly selected hospitalization etc. This is all dependent on any other selection made in the dashboard, so I can't just create flags in the script because a patient may have 5 hospitalizations, but only 3 qualify based on other selections made by the end user in the UI. Is there an easy way to allow end users to make this sort of decision in the UI? What would you recommend to tackle this problem of displaying a distinct observation per patient in different ways?

Thank you!!

Re: allow users to select distinct observations for their selection - most recent, random, etc.

kmstephenson — Mon, 21 Nov 2016 19:07:44 GMT

Any thoughts?

Re: allow users to select distinct observations for their selection - most recent, random, etc.

Anonymous — Mon, 21 Nov 2016 19:29:41 GMT

Not catching your full requirement. But may be you can try alternate states ?

Re: allow users to select distinct observations for their selection - most recent, random, etc.

rwunderlich — Mon, 21 Nov 2016 23:03:13 GMT

You could code the various selection methods (all, latest, etc) as separate expressions with conditional enable based on user selections in an island field. Let me know if you need an example.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: allow users to select distinct observations for their selection - most recent, random, etc.

kmstephenson — Tue, 22 Nov 2016 14:35:42 GMT

An example would be great! Thanks, Rob!

Re: allow users to select distinct observations for their selection - most recent, random, etc.

rwunderlich — Wed, 23 Nov 2016 00:33:26 GMT

Example attached.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: allow users to select distinct observations for their selection - most recent, random, etc.

kmstephenson — Fri, 23 Dec 2016 20:18:43 GMT

Hi Rob,

Thank you for sharing!! This is a very interesting approach. My concern is that I'd like the user to be able to select all, most recent, earliest, etc. at a dashboard level..... and with the approach you shared, I would have to add multiple expressions and conditional logic to each and every chart throughout the dashboard - which I fear would hinder performance... Is this the only approach because of the need for the earliest, latest, etc. to change dynamically with the selections (hence, not being able to create flags in the script)?

Thanks!

Re: allow users to select distinct observations for their selection - most recent, random, etc.

kmstephenson — Tue, 21 Mar 2017 17:50:20 GMT

Hi Rob,

Following up on your suggestion.

With the approach you shared, I would have to add multiple expressions and conditional logic to each and every chart throughout the dashboard - which I fear would hinder performance... Is this the only approach because of the need for the earliest, latest, etc. to change dynamically with the selections (hence, not being able to create flags in the script)? Is there no other option to create a button to subset rows displayed from the master fact table, versus having to add conditional logic to all charts in the UI?

Thanks!

Re: allow users to select distinct observations for their selection - most recent, random, etc.

rwunderlich — Thu, 23 Mar 2017 19:04:06 GMT

I don't think it would impact performance -- the conditionally suppressed expressions would not be calculated. I do see that it could be a pain to have to code all the variations in every chart.

An easier-to-maintain approach would be select the expression using a variable or an indirect field reference. Example of both attached.