Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Search and conditional display of graph

Hi:

I have placed a search object on my sheet.

I want that when user search for a particular data item then chart for that data item is displayed.

For e.g.  my search has only Regions, when user search/select for Region CA,

then chart showing revenue of CA should be displayed.

When user search/select MA then revenue of MA should be displayed.

Can you please tell me how can do this.

Thanks.

1 Solution

Accepted Solutions
eliran_s
Not applicable

Search and conditional display of graph

The search object is a bit irrelevant to this issue, it's more of a display thing and I'll explain.

You can use a conditional rule on the object you wish to display for one region only.

In the chart properties go to General tab, then go to calculation condition and type:

Count(Distinct RegionField)=1

Meaning, only display the chart if one region is selected.

How can the user select? either by a list box, or by a search object as you wanted before.

Hope it helps,

Eliran.

2 Replies
eliran_s
Not applicable

Search and conditional display of graph

The search object is a bit irrelevant to this issue, it's more of a display thing and I'll explain.

You can use a conditional rule on the object you wish to display for one region only.

In the chart properties go to General tab, then go to calculation condition and type:

Count(Distinct RegionField)=1

Meaning, only display the chart if one region is selected.

How can the user select? either by a list box, or by a search object as you wanted before.

Hope it helps,

Eliran.

Not applicable

Search and conditional display of graph

Eliran:

It worked.

Thanks.