calculating index

Fri, 25 Apr 2014 07:31:17 GMT

Hi guys,

Trying to calculate an index value of the measures below but for some reason or another not really working? Works perfectly if no dimensions selected, but once i select a value it breaks as below:

Groups	Measurement	measure 1	measure 2
Result 1	268	3,57 %	1,48 %
Result 2	268	12,08 %	5,02 %
Result 3	268	8,20 %	3,40 %
Result 4	268	31,28 %	12,98 %
Result 5	268	8,07 %	3,35 %
Result 6	268,88 %	11,08 %	4,60 %
Result 7	268	15,34 %	6,37 %
Result 8	268	15,84 %	6,57 %
Result 9	268	34,68 %	14,39 %
Result 10	268	11,88 %	4,93 %
Result 11	268	26,53 %	11,01 %
Result 12	268	8,85 %	3,67 %
Result 13	268	4,61 %	1,91 %
Result 14	268	19,03 %	7,90 %
Result 15	268	2,34 %	0,97 %
Result 16	268	39,76 %	16,50 %

My script as follow for "Measurement". Each individually for "measure 1 and 2"

(Count({<flag_has_group={1},flag_third={1} >}DISTINCT id_table1)/
count({<flag_has_group={1},flag_third={1}>}DISTINCT TOTAL id_table1))
/
(Count({<flag_has_group={1}>}DISTINCT id_table2)/
count({1<flag_has_group={1}>}DISTINCT TOTAL id_table2)))*100

Re: calculating index

Fri, 25 Apr 2014 07:42:10 GMT

Markus,

may you share application with data sample.

This will be easier to help if we will be able to look on it.

regards

Darek

topic Re: calculating index in QlikView

calculating index

Re: calculating index