topic Re: Select Buttong in QlikView

Select Buttong

Thu, 04 Jul 2013 08:41:31 GMT

Hi ,

I am trying to create a button with Select in Field Action that will select Accounts with a set number of Assets.

I have used the expression below but cant seem to get it to work correctly.

='=count(DISTINCT [Serial #])>5 and count(DISTINCT [Serial #]=<10)'

Any suggestions would be gratefully recieved.

many thanks

Paul

Re: Select Buttong

sujeetsingh — Thu, 04 Jul 2013 08:44:19 GMT

Hello ,

Please express details of field and the selection you want .

If possible then give a sample .

Re: Select Buttong

Thu, 04 Jul 2013 10:26:07 GMT

Thanks for the suggestion but I get error in expression.

Re: Select Buttong

Thu, 04 Jul 2013 15:41:30 GMT

I have two tables one with my Accounts in and anothere with Assets in. With a Account number as the key.

What I am trying to do is use a button to select all the Accounts that have between five adn ten assets (using a count of Serial # or i can use ROW ID).

Re: Select Buttong

Fri, 05 Jul 2013 08:52:46 GMT

='=count(DISTINCT [Serial #])=1 or count(DISTINCT [Serial #])=2 or count(DISTINCT [Serial #])=3 or count(DISTINCT [Serial #])=4 or count(DISTINCT [Serial #])=5'

In the end I did this and it worked.