Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jmalenfant
New Contributor II

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
OmarBenSalem
Esteemed Contributor

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

What happens if you just use:

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

6 Replies
OmarBenSalem
Esteemed Contributor

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

What happens if you just use:

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

jmalenfant
New Contributor II

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.

OmarBenSalem
Esteemed Contributor

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

jmalenfant
New Contributor II

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!

jmalenfant
New Contributor II

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?

jmalenfant
New Contributor II

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

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

Community Browser