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

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
NatashaQlik
Contributor
Contributor

Calculating Total based on some colums rather than all columns on UI

I am using star Schema model , with all the fields  on UI in different

dimension table

 

 

Filter drop down -visit name
Filter drop down -SP
Filter drop down -Protocol


I have 3 columns on UI -Protocol,visit_name,SP
i need to calculate two measures

Measure 1- Calculate total Patient count , based on protocol & SP

Measure 2- Calculate total Patient count , based on protocol & SP & visit name -This is easier as all 3 columns are on UI

Challenge is Calculate total count for measure 1 which is based on two columns

If i write set expression and use total formula ignoring visit name columns then on top of page I have 3 filters it ignores the filter i made for visit as well

expr-count({<visit_name>} distinct total <Protocol,SP> Patient)
But because of this expr my filters selection made in visit doesn't show filtered data on grid.

Protocol visit_name SP Patient calculate count=>no_of_Patients- based on  SP & Protocol) count =>no_of_Patients-no_of_Patients based on-> SP & visit & Protocol
11 wk1 Malaria A 5 2
11 wk2 Malaria A 5 1
12 wk5 Malaria B 5 1
11 wk1 Malaria A 5 2
11 Wk3 Malaria A 5 1
11 Wk1 Dengue A 1 1
12 wk5 Dengue B 1 1

 

 

Labels (1)
0 Replies