topic GetPossibleCount() Example in QlikView

GetPossibleCount() Example

aveeeeeee7en — Thu, 27 Mar 2014 08:56:30 GMT

Hi Community

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

Regards

Aviral Nag

Re: GetPossibleCount() Example

jagannalla — Thu, 27 Mar 2014 09:08:11 GMT

Hi,

if you have sales data for different countries.

For eg:

Country	SalesData
India	200
India	400
US	100
US	50
US	20

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

Re: Re: GetPossibleCount() Example

aveeeeeee7en — Thu, 27 Mar 2014 09:27:32 GMT

Can you help me in the Attached Scenario.

Re: Re: Re: GetPossibleCount() Example

tresB — Thu, 27 Mar 2014 09:39:42 GMT

Use show condition expression (layout tab) like:

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

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

...

PFA

Re: Re: Re: GetPossibleCount() Example

jagannalla — Thu, 27 Mar 2014 09:50:49 GMT

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

Re: Re: GetPossibleCount() Example

aveeeeeee7en — Thu, 27 Mar 2014 11:07:48 GMT

Hey Tresesco Thanks a Ton.

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

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

Regards

Aviral Nag

Re: Re: GetPossibleCount() Example

aveeeeeee7en — Thu, 27 Mar 2014 11:08:43 GMT

Thanks Jagan

I love your Approach.

Thank You very Much.

Regards

Aviral Nag