Expression Help

[Anonymous]

Hi,

I have the following table in my Qlikview app:

Club	Electronic	Scanned	Other	Total
Western Bulldogs	1,133	0	0	1,133
Gold Coast Titans	275	0	0	275
Freemantle Dockers	187	0	0	187
St. Kilda	161	0	0	161
Sydney Swans	49	0	0	49
West Coast Eagles	10	0	0	10
Adelaide Crows	5	0	0	5
Port Adelaide Power	2	0	0	2
Fitzroy Lions	0	328	0	328
North Melbourne Kangaroos	0	13	0	13
Total	1,822	341	0	2,163

What expression would I use to get the electronic for each club divided by the grand grand total. So for instance, 1,133 / 2,163 for Western Bulldogs.

My current expression is below, but it only gives me the the electronic divided by the total number of "Type" for the individual club, not them all.

Count({<[Type]={"E"} >}Distinct [Invoice Number])

/

Count({<[Type]={"E","P","S","T"} >}Distinct [Invoice Number])

Many thanks,

Gareth

[tresesco · Accepted solution]

Try using TOTAL keyword like:

Count({<[Type]={"E"} >}Distinct [Invoice Number])

/

Count(TOTAL {<[Type]={"E","P","S","T"} >}Distinct [Invoice Number])

[swuehl]

Maybe just use the TOTAL qualifier:

Count({<[Type]={"E"} >}Distinct [Invoice Number])

/

Count({<[Type]={"E","P","S","T"} >} TOTAL Distinct [Invoice Number])

[Anonymous]

Thanks, that works a treat.

[Anonymous]

Thanks, yours also works.