topic SHOW DIMENSION = CURRENT SELECTIONS, SET ANALYSIS SUM FOR ALL RECORDS in QlikView https://community.qlik.com/t5/QlikView/SHOW-DIMENSION-CURRENT-SELECTIONS-SET-ANALYSIS-SUM-FOR-ALL/m-p/493097#M1138319 <HTML><HEAD></HEAD><BODY><P>This formala is not calculating all records in the database but rather only the records of the selected items.&nbsp; Can someone perhaps help or guide me where I am wrong?</P><P></P><P>(SUM({'1&lt;USERNAME={GetFieldSelections(USERNAME)}&gt;'}timeworked)/60)/COUNT({'1&lt;USERNAME={GetFieldSelections(USERNAME)}&gt;'}DISTINCT(MONTH))</P><P></P><P>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)</P></BODY></HTML> Mon, 30 Sep 2013 09:25:47 GMT 2013-09-30T09:25:47Z SHOW DIMENSION = CURRENT SELECTIONS, SET ANALYSIS SUM FOR ALL RECORDS https://community.qlik.com/t5/QlikView/SHOW-DIMENSION-CURRENT-SELECTIONS-SET-ANALYSIS-SUM-FOR-ALL/m-p/493097#M1138319 <HTML><HEAD></HEAD><BODY><P>This formala is not calculating all records in the database but rather only the records of the selected items.&nbsp; Can someone perhaps help or guide me where I am wrong?</P><P></P><P>(SUM({'1&lt;USERNAME={GetFieldSelections(USERNAME)}&gt;'}timeworked)/60)/COUNT({'1&lt;USERNAME={GetFieldSelections(USERNAME)}&gt;'}DISTINCT(MONTH))</P><P></P><P>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)</P></BODY></HTML> Mon, 30 Sep 2013 09:25:47 GMT https://community.qlik.com/t5/QlikView/SHOW-DIMENSION-CURRENT-SELECTIONS-SET-ANALYSIS-SUM-FOR-ALL/m-p/493097#M1138319 2013-09-30T09:25:47Z