topic Re: Text button with count which opens a new sheet with filtered results in QlikView

Text button with count which opens a new sheet with filtered results

martin_hamilton — Wed, 31 Aug 2016 15:59:53 GMT

@I have a Text Object which is performing a COUNT of records which when selected opens another sheet. I want to filter the next sheet of results based on the COUNT records. I thought about using a sheet action such as Select In Field but have no idea how to apply the search filter using the records i have counted.

My Text Object looks like this:

=Count({<Sub_Contract_End_Date={"$(='>=' & Date(Today(), 'DD/MM/YYYY') & '<=' & Date(Today()+30, 'DD/MM/YYYY'))"}>} Distinct Sub_Number)

Thanks

Martin

Re: Text button with count which opens a new sheet with filtered results

sunny_talwar — Wed, 31 Aug 2016 16:22:21 GMT

What do you plan to filter on?

Re: Text button with count which opens a new sheet with filtered results

martin_hamilton — Wed, 31 Aug 2016 16:34:42 GMT

Hi Sunny

I plan to filter on the field Sub_Number (which would be the Sub_Number' contained in the COUNT value

Thanks

Re: Text button with count which opens a new sheet with filtered results

sunny_talwar — Wed, 31 Aug 2016 16:37:52 GMT

May be use select in field with the following search string for selection

Dimension:

Sub_Number

Search String

='(' & Concat({<Sub_Contract_End_Date={"$(='>=' & Date(Today(), 'DD/MM/YYYY') & '<=' & Date(Today()+30, 'DD/MM/YYYY'))"}>} Distinct Chr(34) & Sub_Number & Chr(34), ', ') & ')'

Re: Text button with count which opens a new sheet with filtered results

martin_hamilton — Wed, 31 Aug 2016 17:24:40 GMT

Hi Sunny

Is this within my existing Text Box in addition to Activate New Sheet or within the sheet I am going to as a sheet event trigger?

If I add within my Text Object it doesnt seem to work.

Thanks

Martin

Re: Text button with count which opens a new sheet with filtered results

sunny_talwar — Wed, 31 Aug 2016 17:39:35 GMT

Did you add the field name with = or without the = sign? You need to have it without. Also, make sure that the casing and spelling of Sub_Number is correct. Not sure what else could be the problem? May be share a sample if it still doesn't work

Re: Text button with count which opens a new sheet with filtered results

martin_hamilton — Wed, 31 Aug 2016 19:47:39 GMT

Hi Sunny - i have a sample but dont know how to upload onto the community?

Re: Text button with count which opens a new sheet with filtered results

sunny_talwar — Wed, 31 Aug 2016 21:14:21 GMT

Here, check this link out

Uploading a Sample

Re: Text button with count which opens a new sheet with filtered results

martin_hamilton — Thu, 01 Sep 2016 07:13:58 GMT

Thanks Sunny

Have uploaded an attachment to my original post.

Thanks for your patience!

Re: Text button with count which opens a new sheet with filtered results

sunny_talwar — Thu, 01 Sep 2016 10:29:59 GMT

Check now and see if this work for you.

Best,

Sunny

Re: Text button with count which opens a new sheet with filtered results

martin_hamilton — Thu, 01 Sep 2016 16:32:49 GMT

Exactly what I was looking for! Thank You!

Re: Text button with count which opens a new sheet with filtered results

sunny_talwar — Thu, 01 Sep 2016 16:44:00 GMT

Awesome, I am glad we were able to get what you wanted. I suggest marking the correct response so that other people can get to the correct information quickly.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny