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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SHOW DIMENSION = CURRENT SELECTIONS, SET ANALYSIS SUM FOR ALL RECORDS

This formala is not calculating all records in the database but rather only the records of the selected items.  Can someone perhaps help or guide me where I am wrong?

(SUM({'1<USERNAME={GetFieldSelections(USERNAME)}>'}timeworked)/60)/COUNT({'1<USERNAME={GetFieldSelections(USERNAME)}>'}DISTINCT(MONTH))

Basically I need only records (dimentions) to show up that has been selected but the calculation should be (sum({1}timeworked/60)/count({1}distinct(MONTH)

Labels (1)
0 Replies