topic Re: Help in creating chart with specific condition in QlikView

Help in creating chart with specific condition

neha2719 — Mon, 20 Sep 2021 16:11:16 GMT

Hi team

I have attached 1 dataset. Please look into this left side is input and right side its desired output. I need to create a chart compcode wise communication percentage. For 1 comp code there are multiple customers and for 1 customer there are multiple lines, if atleast one line hav enabled status it is considered as enabled and if none of the line have enabled it is considered as disabled.

Please let me know if any questions.

Please do not share the Qlik file as I wont be able to open it.

Thanks in advance.

Re: Help in creating chart with specific condition

chrismarlow — Mon, 20 Sep 2021 17:19:04 GMT

Hi,

Maybe try;

Enabled =count(DISTINCT If(Communication='Enabled',Customer,Null()))/count(DISTINCT Customer)

Disabled =1-(count(DISTINCT If(Communication='Enabled',Customer,Null()))/count(DISTINCT Customer))

Cheers,

Chris.

Re: Help in creating chart with specific condition

stevejoyce — Mon, 20 Sep 2021 17:41:39 GMT

Similar to @chrismarlow but with set analysis

Enabled =count(DISTINCT {< Communication*={'Enabled'} >}Customer )/count(DISTINCT Customer)

Disabled =1-(count(DISTINCT {< Communication*={'Enabled'} >} Customer )/count(DISTINCT Customer))

Re: Help in creating chart with specific condition

neha2719 — Tue, 21 Sep 2021 09:28:13 GMT

Thank you for reply this worked, i couldn't think of disabled expression we can write this. Thank you so much

Re: Help in creating chart with specific condition

neha2719 — Tue, 21 Sep 2021 09:29:31 GMT

Thank you Steve, this works perfectly, I couldnt think of that we can write expression for disabled in the same manner.