topic Re: Button Creation Based on Field Selection in QlikView

Button Creation Based on Field Selection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I would like to create a button or buttons (open to other options) to show items that have a Sign Off Date vs. items that do not have a Sign Off Date. The Sign Off Date field just has dates in each cell or a "-". Looking for some suggestions/assistance on how to do this.

Thanks in advance!

Re: Button Creation Based on Field Selection

BalaBhaskar_Qlik — Wed, 01 Aug 2018 15:53:30 GMT

Your data may like this:

Item, SignoffDate

1, 8/1/18

2, -

3, 7/15/18

4, 7/14/18

5, 7/12/18

6, -

Try Expression like this:

Button - Actions - Add - Select possible - Field - Count({<SignoffDate=>}Item) & 'vs' & Count({<SignoffDate = {''}>}Item).

Re: Button Creation Based on Field Selection

agomes1971 — Wed, 01 Aug 2018 16:20:42 GMT

Hi,

please see this:

Hide/show an Object with button set variable

HTH

André Gomes