Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
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))
I am not sure I understand. Can you expand on what exactly you are looking to get?
Hi,
So basically I wanted something like the attached in Qlikview, maybe as a Pivot Chart
Thank you