Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator III
Creator III

Need Suggestion..

Hi Community,

I have Dashboard, suppose i have a BAR char, customer wise data,

when i am click any particular Customer bar i want show details report in Straight table or pivot table...

please give me suggestions, how present data.....

5 Replies
Gysbert_Wassenaar

Create the straight table. When you click on a bar in the bar chart the straight table will be filtered automatically too. If you don't want to show the straight table if no customer is selected then enable the option Conditional on the Layout tab of the properties window and enter an expression =getselectedcount(CustomerIDFieldHere). Replace CustomerIDFieldHere with the name of your customer field.


talk is cheap, supply exceeds demand
MK_QSL
MVP
MVP

Create a Straight Table or Pivot Table as per your requirements and go to Layout tab

Conditional Show

GetSelectedCount(Customer)>0

Now this table will only visible one you have at least one customer selected... How this help.

datanibbler
Champion
Champion

You can either set up your straight table (as a separate object, not in a container_box) with a visibility_condition and place it in the same position as your bar_chart and set the barchart with the opposite visibility_condition so when someone clicks on a bar (which you can find out with GETFIELDSELECTIONS()) the barchart will disappear and the details_table will appear - in that case, don't forget to implement sth. like a "Back" button to revert it ...

Best regards,

DataNibbler

paulwalker
Creator III
Creator III
Author

Hi,

I have done something, please check once..

i have BAR chart when i am click any bar i need to display detail report...

i have created one variable(vShow) and Close button,

when i am click close button i need to close Detail report.....

Gysbert_Wassenaar

See attached qvw


talk is cheap, supply exceeds demand