topic Re: Expression Help in QlikView

Expression Help

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the following table in my Qlikview app:

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

Re: Expression Help

tresB — Mon, 09 Oct 2017 09:02:10 GMT

Try using TOTAL keyword like:

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

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

Re: Expression Help

swuehl — Mon, 09 Oct 2017 09:02:53 GMT

Maybe just use the TOTAL qualifier:

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

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

Re: Expression Help

Anonymous — Mon, 09 Oct 2017 09:04:47 GMT

Thanks, that works a treat.

Re: Expression Help

Anonymous — Mon, 09 Oct 2017 09:04:57 GMT

Thanks, yours also works.