topic Data Island as a Chart Dimension in QlikView

Data Island as a Chart Dimension

Anonymous — Sat, 16 Nov 2024 05:15:04 GMT

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.

Re: Data Island as a Chart Dimension

sunny_talwar — Wed, 14 Nov 2018 20:04:46 GMT

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))

Re: Data Island as a Chart Dimension

Anonymous — Wed, 14 Nov 2018 20:44:34 GMT

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

Re: Data Island as a Chart Dimension

Anonymous — Wed, 14 Nov 2018 20:46:40 GMT

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

Re: Data Island as a Chart Dimension

sunny_talwar — Wed, 14 Nov 2018 20:54:13 GMT

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

Re: Data Island as a Chart Dimension

Anonymous — Wed, 14 Nov 2018 21:26:32 GMT

Hi,

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

Thank you

Re: Data Island as a Chart Dimension

sunny_talwar — Thu, 15 Nov 2018 01:12:33 GMT

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