Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
skiruthigadevi
Partner - Creator
Partner - Creator

Regarding displaying format

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

1 Solution

Accepted Solutions
neelamsaroha157
Specialist II
Specialist II

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

View solution in original post

10 Replies
neelamsaroha157
Specialist II
Specialist II

Use GetPossibleCount function instead of GetSelectedCount.

sunny_talwar

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

skiruthigadevi
Partner - Creator
Partner - Creator
Author

Hi Friends,

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

thanks,

Kiruthiga

sunny_talwar

screenshot?

skiruthigadevi
Partner - Creator
Partner - Creator
Author

attached,Thank you!

skiruthigadevi
Partner - Creator
Partner - Creator
Author

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

sunny_talwar

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

skiruthigadevi
Partner - Creator
Partner - Creator
Author

Hi Sunny,

It's not working for the other scenario.

Attached for your reference.

Thanks!

neelamsaroha157
Specialist II
Specialist II

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