topic Re: QV: Reflect single value in textbox in QlikView

QV: Reflect single value in textbox

Anonymous — Mon, 03 Apr 2017 20:43:09 GMT

Dear all,

I am trying to create a textbox that reflects a single string value depending on the current selections and a formula integrated in the textbox itself.

Textbox currently contains the following query: =if([Event Year]=2017), 'Resort')

My Database is organized this way:

Event Year	Event	Resort	Game
2017	World Cup	A-City	Game 1
2017	World Cup	A-City	Game 2
2016	World Cup	B-City	Game 1
2016	World Cup	C-City	Game 2
2017	European Cup	D-City	Game 1
2016	European Cup	E-City	Game 1

Now, as soon as the user filters to event "World Cup", the textbox should be able, with the help of the if-formula, to reflect the respective single value, as for 2017 there is only one distinct value in this column?

However in order that the formula correctly shows "A-City", I have to filter to Event year 2017 with the help of a listbox.

Does anybody see the mistake I am making, or the information I am missing?

Thanks a lot

Benedikt

Re: QV: Reflect single value in textbox

vishsaggi — Mon, 03 Apr 2017 21:44:35 GMT

Try this in your text box:

= Concat(DISTINCT IF([Event Year] = '2017', Resort), '|')

Re: QV: Reflect single value in textbox

craigsutton — Mon, 03 Apr 2017 23:07:59 GMT

Not sure exactly how you wanted to see it, but here is a way to only show a value if a single event is selected:

=If(GetSelectedCount(Event)=1,Concat({<[Event Year]={2017}>} DISTINCT Resort))

Re: QV: Reflect single value in textbox

Anonymous — Tue, 04 Apr 2017 07:50:31 GMT

Thanks Craig and Vishwarath, both your options work fine and give the correct results.