Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text box vlookup?

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?

yesno.PNG.png

mechant.PNG.png

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
MVP & Luminary
MVP & Luminary

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.


talk is cheap, supply exceeds demand
Not applicable

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.

MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand

View solution in original post

MVP
MVP

May be like attached sample?

Not applicable

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!