Discussion Board for collaboration on QlikView Layout & Visualizations.
I'd like to aggregate the count of text categories across multiples measures in a Pivot Table.
The underlying data looks as follows, the categories are always - OK, Needs Attention, At Risk, High Risk:
I'd like the resulting pivot table to look like this:
Thanks in advance!
Go to Solution.
Something like this
Load the data using the CrossTable load
CrossTable(Field, Value, 2)
LOAD * INLINE [
Application Ref, Migration Wave, Design Status, Build Status, Production Readiness
ABC, P1 10, At Risk, Needs Attention, OK
DEF, P1 10, OK, OK, OK
GHI, P2 11, High Risk, High Risk, At Risk
JKL, P1 9, Needs Attention, OK, OK
MNO, P2 11, At Risk, Needs Attention, Needs Attention
and then use this
1) Migration Wave
2) Count(Value)/Max(TOTAL <[Migration Wave], Value> Aggr(Count(Value), [Migration Wave], Field, Value))
View solution in original post
Sunny, can't thank you enough for the solution and quick response!!!! This has worked brilliantly!!