Data Island as a Chart Dimension

[Anonymous]

Hello all,

PFA,

  I have attached sample qwv and the scores dashboard where I am deriving the scores. So I have created text boxes which holds expressions and the labels. My challenge is that I cannot link the data Island to the main table so that i can create charts.

pleas assist.

[sunny_talwar · Accepted solution]

Try these expressions

Major Score

Pick(Match(Issue_Rule,'<10% Major issues','11 -20% Major issues','>21% Major issues'),
if(num(count({$<Flags={'MajFlag'}>}Flags)/count({$<Flags={'MajFlag','LtdFlag'}>}Flags),'#0.00%')<0.1,7),
if(num(count({$<Flags={'MajFlag'}>}Flags)/count({$<Flags={'MajFlag','LtdFlag'}>}Flags),'#0.00%')>= 0.11 and num(count({$<Flags={'MajFlag'}>}Flags)/count({$<Flags={'MajFlag','LtdFlag'}>}Flags),'#0.00%')<=0.20,10),
if(num(count({$<Flags={'MajFlag'}>}Flags)/count({$<Flags={'MajFlag','LtdFlag'}>}Flags),'#0.00%')>=0.21,14))

Limited Score

Pick(Match(Issue_Rule,'<79% Limited issues','80-89% Limited issues','>90% Limited issue'),
if(Num(count({$<Flags={'LtdFlag'}>}Flags)/count({$<Flags={'MajFlag','LtdFlag'}>}Flags),'#0.00%')<0.79,12),
if(Num(count({$<Flags={'LtdFlag'}>}Flags)/count({$<Flags={'MajFlag','LtdFlag'}>}Flags),'#0.00%')>= 0.80 and Num(count({$<Flags={'LtdFlag'}>}Flags)/count({$<Flags={'MajFlag','LtdFlag'}>}Flags),'#0.00%')<= 0.89,8),
if(Num(count({$<Flags={'LtdFlag'}>}Flags)/count({$<Flags={'MajFlag','LtdFlag'}>}Flags),'#0.00%')>=0.90,5))

[Anonymous · Accepted solution]

Thank you for your assistance. Can I put the scores in one column then categorize them in another column as Limited or Major?

[Anonymous]

I marked this correct by mistake, pardon me. If you can please provide me with your response.

[sunny_talwar]

I am not sure I understand. Can you expand on what exactly you are looking to get?

[Anonymous]

 Hi,

So basically I wanted something  like the  attached in Qlikview, maybe as a Pivot Chart

Thank you

[sunny_talwar]

I am not sure I understand the Excel... where is Metric field in the dashboard?