Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show the correct number if terms in summation

Hello everyone!

Are in desperate need of help. Hope some of you genuises can help me.

I have the following data;

PatientNo / Visit / Sex (female and male) / HomeTown (Aneby, Eksjo, Nassjo)

Each PatientNo have 1 or more Visits.

Shows the number om visits (Sum(Visit)) and visitors (TextCount(Distinct PatientNo)) per dimensions HomwTown or Sex in a straight table. So far everything i exactly as I want it to be.

Shows the visits and visitors per dimension PatientNo in an other straight table if the number om visits exceeds 3. Works great.

Now I want to show number of visits and visitors if the number per unik visitors exceeds 3. This too I want to show per HomeTown or Sex as 1 dimension. As 2 dimension I want PatientNo. Is it possible? How do I do this?

Carola

0 Replies