topic Re: Text box vlookup? in QlikView

Text box vlookup?

Mon, 24 Nov 2014 10:08:15 GMT

Hey guys,

hopefully somebody can help me with this. I am trying to create a text box that displays if there is a promotion on in that store. I also would like it that if you clicked on the textbox it activates a table that is filtered by the store in question.

For example Best Buy would display as yes (because there is an instant saving promotion there) and when I click it it activates a table with all the Best Buy info listed.

Any ideas?

Re: Text box vlookup?

Gysbert_Wassenaar — Mon, 24 Nov 2014 10:14:43 GMT

Perhaps something like this: =if(sum({<Store={'Best Buy'}>}[Instant Savings]),'yes','no'). If not, please post a .qvw document with data so we can at least make an educated guess instead of a blind guess.

Re: Text box vlookup?

Mon, 24 Nov 2014 10:24:38 GMT

Thankyou.

This works when the table is already filtered to show only best buy products. Is it possible to have the text box act as both a button and a filter?

For example when I click the text box it activates a table filtered only by the specific product?

The dataset is huge and we have a very private data policy here but maybe I can put something together.

Re: Text box vlookup?

Gysbert_Wassenaar — Mon, 24 Nov 2014 10:28:45 GMT

Add a Select in Field action to the text object so that clicking the text object results in a selection.

Re: Re: Text box vlookup?

tresB — Mon, 24 Nov 2014 10:32:04 GMT

May be like attached sample?

Re: Text box vlookup?

Mon, 24 Nov 2014 10:40:42 GMT

Thank you so much. I didn't realise I could do this with select in field which is a very simple solution.

You guys rock!