topic Re: Percentages in Grid Chart in QlikView

Percentages in Grid Chart

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

Wondering if you can help me. I have a Grid Chart showing a count of requests, this has two dimensions. One is order type and the other is Delivery date.

I want to create a Grid Chart showing the percentages, with each order type, for the delivery dates. I have tried using the relative button but this uses percentages across all types. I want each order type row to add up to 100%.

I'm also using an IF statement within the expression as I'm only interested in orders created in the last week.

My expression is below :

=NUM(count(IF([Order Date]>(today(1)-8) AND [OrderDate]<(today(1)),[Order No])) / count(total IF([Order Date]>(today(1)-8) AND [Order Date]<(today(1)),[Order No]))*100,'##.##')

Suggestions welcome?

Re: Percentages in Grid Chart

sunny_talwar — Wed, 12 Oct 2016 16:18:40 GMT

May be you need to add the Total Qualifier field here:

=Num(Count(If([Order Date]>(Today(1)-8) and [OrderDate]<(Today(1)),[Order No])) / Count(TOTAL <[order type]> If([Order Date]>(Today(1)-8) and [Order Date]<(Today(1)),[Order No]))*100,'##.##')

Re: Percentages in Grid Chart

william_denholm — Thu, 13 Oct 2016 09:27:25 GMT

Ideal, thank you. I had tried a Total Qualifier, but had it in the wrong place!