topic GetCurrentSelections() in QlikView

GetCurrentSelections()

Mon, 06 Jul 2015 17:00:56 GMT

I am trying to write an IF() that will return a value when a field within a group is selected. So I have something along the lines of whats below. However, the function is returning Sum(Sales) when any field in Annual Analysis is selected, not just 2015 YTD like I want. Any suggestions? Thanks in advance.

=IF(GetCurrentSelections([Annual Analysis]) = '2015 YTD', Sum(Sales)))

Re: GetCurrentSelections()

sunny_talwar — Mon, 06 Jul 2015 17:04:49 GMT

Try this:

=If(WildMatch(GetFieldSelections([Annual Analysis]), '2015 YTD'), Sum(Sales))

Re: GetCurrentSelections()

Mon, 06 Jul 2015 17:15:42 GMT

Yes that worked! how does WildMatch work?

Re: GetCurrentSelections()

antoniotiman — Mon, 06 Jul 2015 17:16:03 GMT

If You haveDimension [Annual Analysis] in Your Group try

If(GetCurrentField(YourGroup)='Annual Analysis',Sum({<[Annual Analysis]={'2015 YTD'}>} Sales))

Re: GetCurrentSelections()

sunny_talwar — Mon, 06 Jul 2015 17:17:46 GMT

Not entirely sure what you are doing and how you data looks. if what ANTONIO‌ said did not work, would you be able to share a sample?

Best,

Sunny

Re: GetCurrentSelections()

Mon, 06 Jul 2015 17:19:39 GMT

I spoke too soon, =If(WildMatch(GetFieldSelections([Annual Analysis]), '2015 YTD'), Sum(Sales)) worked. How does WildMatch work?

Re: GetCurrentSelections()

sunny_talwar — Mon, 06 Jul 2015 17:25:11 GMT

Here is an image from QV Help page:

I hope this will clarify things.

Best,

Sunny