topic Regarding displaying format in QlikView

Regarding displaying format

skiruthigadevi — Fri, 13 Jul 2018 15:53:59 GMT

Hi Friends,

I appreciate your time. I am looking for your help in my scenario. I have Vendor Number, Vendor Name and Vendor_Final in my table.

when I select single vendor number my list box should show the vendor details and in case if I select more than one vendor it should display "Multiple Vendor selected" message.

my calculation is showing "multiple vendor selected" message when I select multiple vendor number but when I select multiple vendor names it is not showing the "multiple vendor selected" message. I have attached a sample application for your reference.

Thanks,

Kiruthiga

Re: Regarding displaying format

neelamsaroha157 — Fri, 13 Jul 2018 15:57:31 GMT

Use GetPossibleCount function instead of GetSelectedCount.

Re: Regarding displaying format

sunny_talwar — Fri, 13 Jul 2018 16:11:04 GMT

Might make sense to leave the first GetSelectedCount() as is

='VENDOR :'&if(GetSelectedCount([Vendor_Number]) = 0,

[Vendor_Number]&CHR(32)&'-'&CHR(32)&Vendor_Name_Final,

if(GetPossibleCount([Vendor_Number])=1,

[Vendor_Number]&CHR(32)&'-'&CHR(32)&[Vendor_Name],

if(GetPossibleCount([Vendor_Number])>1,'Multiple Vendors Selected')))

Re: Regarding displaying format

skiruthigadevi — Fri, 13 Jul 2018 17:46:10 GMT

Hi Friends,

Appreciate your time. Unfortunately both didn't worked. attached the screenshot of what I got when I changed the expression.

thanks,

Kiruthiga

Re: Regarding displaying format

sunny_talwar — Fri, 13 Jul 2018 17:47:06 GMT

screenshot?

Re: Regarding displaying format

skiruthigadevi — Fri, 13 Jul 2018 17:48:12 GMT

attached,Thank you!

Re: Regarding displaying format

skiruthigadevi — Fri, 13 Jul 2018 17:50:29 GMT

Hi Neelam,

Thank you and appreciate your time. The expression looks like attached image when nothing is selected but it should display vendor name final instead.

Thank you!

Kiruthiga

Re: Regarding displaying format

sunny_talwar — Fri, 13 Jul 2018 17:52:45 GMT

This is what neelamsaroha1575‌ suggested... try this

='VENDOR :'&if(GetPossibleCount([Vendor_Number]) =0,

[Vendor_Number]&CHR(32)&'-'&CHR(32)&Vendor_Name_Final,

if(GetPossibleCount([Vendor_Number])=1,

[Vendor_Number]&CHR(32)&'-'&CHR(32)&[Vendor_Name],

if(GetPossibleCount([Vendor_Number])>1,'Multiple Vendors Selected')))

Re: Regarding displaying format

skiruthigadevi — Fri, 13 Jul 2018 17:59:59 GMT

Hi Sunny,

It's not working for the other scenario.

Attached for your reference.

Thanks!

Re: Regarding displaying format

neelamsaroha157 — Fri, 13 Jul 2018 18:11:17 GMT

Try this -

='VENDOR :'&

If(GetSelectedCount(Vendor_Number) + GetSelectedCount(Vendor_Name)=0, 'No Vendor Selected',

if(GetPossibleCount([Vendor_Number]) =0,

[Vendor_Number]&CHR(32)&'-'&CHR(32)&Vendor_Name_Final,

if(GetPossibleCount([Vendor_Number])=1,

[Vendor_Number]&CHR(32)&'-'&CHR(32)&[Vendor_Name],

if(GetPossibleCount([Vendor_Number])>1,'Multiple Vendors Selected'))))

Re: Regarding displaying format

skiruthigadevi — Fri, 13 Jul 2018 18:14:57 GMT

It worked.Thank you!