Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
william_denholm
Contributor III
Contributor III

Percentages in Grid Chart

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?

2 Replies
sunny_talwar

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,'##.##')

william_denholm
Contributor III
Contributor III

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