Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
Partner
Partner

set modifier issues - trying to do a simple function

Hi all,

I'm sure this it very simple and that I'm missing something small, but can't find any posts or info that helping.

I'm trying to make a KPI for # of hospital visits.

enc_type: column in data that has"hospitalization information" as an option

I've tried various approaches ( think i need count and not sum)

Here's the closes I got, the syntax works but getting 0 results when I know there is data and I selected all years in the app using a filter for admit_date

Would love any feedback - i know i'm close but just missing something

count({$<encounterid = {"P({1<enc_type={'Hostpitalization Information'"}>}encounterid)

Thanks! !

1 Solution

Accepted Solutions
Partner
Partner

Re: set modifier issues - trying to do a simple function

What happens if you just use:

count({1<enc_type={'Hostpitalization Information'"}>}encounterid

View solution in original post

6 Replies
Partner
Partner

Re: set modifier issues - trying to do a simple function

What happens if you just use:

count({1<enc_type={'Hostpitalization Information'"}>}encounterid

View solution in original post

Partner
Partner

Re: set modifier issues - trying to do a simple function

Thanks -I got an error when I typed what you suggested so modified to count({1<enc_type={'Hostpitalization Information'}>}encounterid)

still getting "0" when I know there is data.

Partner
Partner

Re: set modifier issues - trying to do a simple function

Can you share a sample application?

To directly test on it?

That would be much easier !

Thanks

Partner
Partner

Re: set modifier issues - trying to do a simple function

Hi - here's the app. The 4th sheet is where I've been trying things out.

I'd like a KPI for # encounterid with enc_type = "Hosptitalization Information" as well as a similar KPI that counts patid (i.e. patients) instead of encounterid (i.e.visits)

I'm wondering if it has something to do w/ all of the synthetic keys and links? I couldn't figure out how to remove them. the data shouldn't require any additional keys, the database seems to be set up correctly

thanks!

Partner
Partner

Re: set modifier issues - trying to do a simple function

in the data manager, the links and associations aren't appearing even though the data are loaded. Do you have any suggestions on how to see and remove the synthetic links created by Sense?

Partner
Partner

Re: set modifier issues - trying to do a simple function

Apparently I just can't spell - this worked thanks!