Please see the attached sample file and let me know if that helps, your explanation isn't that thorough so if you need further help it would be great if you could supply an example file
Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.
What you are describing is, as far as I know, not possible in QlikView. Clicking a bar in a chart simply makes a selection in a field (or fields) based on the dimension(s). You could set up a text box that appears when a single value is selected in your "Accounts" field, but this will trigger regardless of where the selection was made (in this graph, in another graph or table, in a listbox, etc) - depending on the structure of the your application, this may or may not be helpful.
You could probably work around this by copying your dimension field a second time inside the load script:
Load Accounts, Accounts as AccountsForGraph;
And using AccountsForGraph in your chart. You can then base your textbox display trigger on this new field.
Another similar option would be to place your graph in an alternate state, passing all the parameters from the default state, which would prevent the click on the bar from impacting the primary model's selection but still allow you to map it to a text object's visible property.
Don't have a License so cannot open the QVW. Can you please provide snapshots??
My question in details is ---
I have a bar chart showing top 10 accounts for Sum(Sales) ... When I click on any Bar (Account Name) --- this click should enable a Text Box as Pop Up and the reltaive information regarding the Account like Name, Number, Address, State, other Metrics should be visible in that Text box. I will hard coe all this in a Text Box but I want to know how to show it using a Bar.
hi
I have tried FIeld Event Trigger on Account name which is taking me to another Sheet. In that Sheet, I have made this Text box. Now when I click the Bar, it takes me to Sheet2 where this Text Box is but my Client don't want another sheet he wants that the Text Box should be invisble and it should open on the same sheet with a Bar Click.
One option normally being used in similar situation is to display desired info through 'Text as pop-up' in expression tab. You just need to create new expression which would be concatenation of label and expression with chr(10) as line break to build all the required info to be shown in pop-up. You should uncheck bar for this optionin expression tab, also uncheck pop-up labels in presentation as we are creating pop up manually.
