topic button help in QlikView

button help

Wed, 16 Dec 2015 08:40:29 GMT

Hi,

A solution was kindly provided to us via the community which when we selected a button on our app it brought through a certain amount of properties meeting a criteria

= '(' & '"' & concat({$ <UPRN={"=Avg([NPV Total])<-4999"}>} UPRN, '"' & '|' & '"') & '"' & ')'

I have tried to replicate this on another app but I am struggling with the expression. Hope people can help.

As per the image below. If we take Safeguarding what we would like to happen is when we click this it activates all live safeguarding cases. Each safeguarding case has the following fields:

- Complaint ID

- Date Logged

- Compliant Type

- Complaint Sub Type

- Neighbourhood Officer

- Tenancy Sequence Nr

Here is latest expression I have tried:

= '(' & '"' & concat({$ <[Complaint Type]={"=Count([Qlikview_Safeguarding_Live_Cases.complaint_id]"}>} [Complaint Type], '"' & '|' & '"') & '"' & ')'

Any help would be appreciated.

Chris

Re: button help

tresB — Wed, 16 Dec 2015 08:58:04 GMT

Don't you wish to compare your count with a number or other calculation like

= '(' & '"' & concat({$ <[Complaint Type]={"=Count([Qlikview_Safeguarding_Live_Cases.complaint_id] > XXX"}>} [Complaint Type], '"' & '|' & '"') & '"' & ')'

The comparison (>XXX) would be yours.

Re: button help

Wed, 16 Dec 2015 09:05:38 GMT

No, the purpose is solely to select the cases so then this can be focused on. Where this helps for example is one of the charts we have. This is an extension of the image earlier. The chart shows current workloads by Officer (i.e no of safeguarding, voids, ASB and Evictions). If we can select just one type of workload, i.e safeguarding through the button the chart would show just that activity by officer - this is what we are wanting.

Re: button help

tresB — Wed, 16 Dec 2015 09:15:23 GMT

<[Complaint Type]={"=Count([Qlikview_Safeguarding_Live_Cases.complaint_id]"}

The set section above is not correct, I guess. Could you write in words - what you want to mean by this? Consider those [Complaint Type] s, that are....?

Re: button help

Wed, 16 Dec 2015 13:58:16 GMT

Try this, it should return all complaint types concatenated were there is at least one Qlikview_Safeguarding_Live_Cases.complaint_id. Although without an example app to write it in I may have missed syntax (hopefully not)

= '(' & '"' & concat({$ <[Complaint Type]={"=Count([Qlikview_Safeguarding_Live_Cases.complaint_id] ) > 0"}>} [Complaint Type], '"' & '|' & '"') & '"' & ')'

Re: button help

Thu, 17 Dec 2015 10:21:58 GMT

Hi Carly,

Thanks - yes sorry don't want to share content of the app.

I have put this in along with 'Qlikview_Safeguarding_Live_Cases.Safeguarding ComplaintID' in the 'field' of button properties' however, nothing happens:

= '(' & '"' & concat({$ <[Complaint Type]={"=Count([Qlikview_Safeguarding_Live_Cases.Safeguarding ComplaintID]) > 0"}>} [Complaint Type], '"' & '|' & '"')& '"' & ')'

It says expression OK but there red lines under end of syntax...

Chris

Re: button help

Thu, 17 Dec 2015 16:56:16 GMT

I tried to recreate you data by doing inline load of fake fields:

Table:

Load

Inline [

Complaint Type, Qlikview_Safeguarding_Live_Cases.Safeguarding ComplaintID

Type1, 11223344

Type2, 34566889

Type3, 43565678

Type1, 66575477

Type4,

];

The expression works for me on my data so all I can think of is a field spelling issue. Try deleting the fields and pasting them from the fields menu in the expression to check this.

p.s If you do get it working I did notice you will need to add the distinct into the expression so the type doesn't duplicate if it is in the data multiple times

= '(' & '"' & concat({$ <[Complaint Type]={"=Count([Qlikview_Safeguarding_Live_Cases.Safeguarding ComplaintID]) > 0"}>}distinct [Complaint Type], '"' & '|' & '"')& '"' & ')'