topic Re: Help need in count with variable. in QlikView

Help need in count with variable.

Anonymous — Thu, 04 Jun 2015 12:01:37 GMT

Hi All,

I am trying to get count of Test

if I select ID in my list box all the Test should be counted for selected ID's in Listbox and count should be store into a variable .

RCYC:

load * Inline [

];

Test:

load * Inline [

Test,ID

1,1

2,1

3,1

4,1

5,2

6,2

7,2

8,3

9,3

10,4

];

For more information sample app is attached.

Thanks

BKC

Re: Help need in count with variable.

sunny_talwar — Thu, 04 Jun 2015 12:07:32 GMT

From what I understand, try defining you variable using Concat function instead of GetFieldSelections. May be like this:

=Concat(DISTINCT ID, ',')

Attaching your qvw for reference

Best,

Sunny

Re: Help need in count with variable.

IAMDV — Thu, 04 Jun 2015 12:15:09 GMT

Hi,

You can use GetFieldSelections() function but you need to specify the third parameter which is optional. You need something like this:

=GetFieldSelections(ID, ',',1000)

Where 1000 values is the limit.

I wouldn't use Concat() because if there's nothing selecting then Concat() would return all the values. To tackle this issue you need a conditional statement (IF) which might be inefficient.

Hope this helps!

Cheers,

www.QlikShare.com

Re: Help need in count with variable.

ankit777 — Thu, 04 Jun 2015 12:16:36 GMT

instead of GetFieldSelections u can use this

=if(GetSelectedCount(ID)>0, Concat(ID,','))

Re: Help need in count with variable.

Anonymous — Thu, 04 Jun 2015 12:17:31 GMT

Thank you

It will give me some Idea.

Re: Help need in count with variable.

MayilVahanan — Thu, 04 Jun 2015 12:19:06 GMT

Are you looking for this?

Create a variable named something like "vTestCount"

And add expression like = If(GetselectedCount(ID), Count(Test), 0)

// If user select ID field, then vTestCount counts the Test value else 0 is store for that variable

Re: Help need in count with variable.

IAMDV — Thu, 04 Jun 2015 12:21:56 GMT

BKC - In case you're interested in understanding Meta Data functions, you can check the following video:

http://qlikshare.com/241/

Cheers,

Re: Help need in count with variable.

sasiparupudi1 — Thu, 04 Jun 2015 13:00:22 GMT

Can you use ?

Count({$} Test )