Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aveeeeeee7en
Specialist III
Specialist III

GetPossibleCount() Example

Hi Community

Can anybody gave me the Example of GetPossibleCount() with Attachment.

Regards

Aviral Nag

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Use show condition expression (layout tab) like:

SubStringCount(Concat(Level,';'),'1') -- for Level 1

SubStringCount(Concat(Level,';'),'2') -- for Level 2

...

PFA

View solution in original post

6 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III

Hi,

if you have sales data for different countries.

For eg:

CountrySalesData
India200
India400
US100
US50
US20

Now when you select India from country and in text object if you place GetPossibleCount(SalesData) it returns 2. B'coz we have 2 possible values for India. If you clear it will give 5

Thanks,

Jagan

aveeeeeee7en
Specialist III
Specialist III
Author

Can you help me in the Attached Scenario.

tresesco
MVP
MVP

Use show condition expression (layout tab) like:

SubStringCount(Concat(Level,';'),'1') -- for Level 1

SubStringCount(Concat(Level,';'),'2') -- for Level 2

...

PFA

jagannalla
Partner - Specialist III
Partner - Specialist III

Hi,

You can't use expression in getpossiblecount, we can use only fieldnames. Please try to convert all your expressions into script level. As below,

Test:

LOAD emp_name AS EmpID,

     emp_name AS Name,

     superior AS [Reporting To],

     emp_sub_department AS Department,

     emp_code,

     emp_location

  

FROM

(ooxml, embedded labels, table is Sheet1);

Hierarchy:

Hierarchy (EmpID,[Reporting To],Name,Manager,Name,EmpTree,'/',Level)

LOAD *

RESIDENT Test;

DROP TABLE Test;

LOAD EmpID,

if(Level=1,Name&chr(13)&emp_location&chr(13)&Department) as Level1,

if(Level=2,Name&chr(13)&emp_location&chr(13)&Department) as Level2,

if(Level=3,Name&chr(13)&emp_location&chr(13)&Department) as Level3,

if(Level=4,Name&chr(13)&emp_location&chr(13)&Department) as Level4

Resident Hierarchy;

- Now add Level1 into listbox and in listbox properties -> Layout -> Show (enable conditional) and paste this exp =if(GetPossibleCount(Level1)>0,True(),False())

- Repeat this step for other listboxes by changing the expression. i.e. instead of Level1 use Level2, Level3 and Level4

Hope it helps you

Cheers!!!

Jagan

aveeeeeee7en
Specialist III
Specialist III
Author

Hey Tresesco Thanks a Ton.

This was something Awesome.............. Loved it..

Thanks You very Much. You made my day......... 🙂

Regards

Aviral Nag

aveeeeeee7en
Specialist III
Specialist III
Author

Thanks Jagan

I love your Approach.

Thank You very Much.

Regards

Aviral Nag