Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
RutiTaumanRubin
Creator
Creator

Total Function behavior

Hi,

I have created measure  that in the denominator ignore Year Dim:

count({<ACTION_TYPE={"OPEN"}>} Distinct ID)
/
count({<Year=,TK={'$(=$(V_Max_Last_Appr_TK))'}>} distinct ID)

 

When I defined KPI with this measure I received the number 103% as a result.

When I defined as a graph\table with this measure and Year field as a dim I received the number 106% as a result and the number 103% as total function Auto (You can see printscreen in the attachment)

Do you know why its occur?

 

Thanks!

 

 

1 Solution

Accepted Solutions
tresesco
MVP
MVP

You used Year in set analysis causing that disregards the year field selection. For disregarding dimension in a chart for totaling, try like:

count({<ACTION_TYPE={"OPEN"}>} Distinct ID)
/
count(Total <Year> {<TK={'$(=$(V_Max_Last_Appr_TK))'}>} distinct ID)

View solution in original post

1 Reply
tresesco
MVP
MVP

You used Year in set analysis causing that disregards the year field selection. For disregarding dimension in a chart for totaling, try like:

count({<ACTION_TYPE={"OPEN"}>} Distinct ID)
/
count(Total <Year> {<TK={'$(=$(V_Max_Last_Appr_TK))'}>} distinct ID)