topic Re: Bar chart should not effect with selection in QlikView

Bar chart should not effect with selection

polisetti — Mon, 14 Jul 2014 10:45:52 GMT

Hi,

In my reports i had one bar chart and one straight table. When ever i click on bar chart the bottom straight table should filter according to the selection made in bar chart. Now the requirement is the data in straight table should filter but the bar chart should on filter on selection.

Ex:

I have a dimension month :jan, feb, mar , apr .If i select on mar the straight table should show data related to mar, but the bar chart should show all the 4 months.

I tried Set reference option in properties, but it is breaking at some times.

Is there any other process to show like this ?

Thanks,

Polisetti

Re: Bar chart should not effect with selection

ashfaq_haseeb — Mon, 14 Jul 2014 10:52:34 GMT

Hi,

Create a separate state for bar chart.

Look at alternate states.

Look at the attached document

Regards

ASHFAQ

Re: Bar chart should not effect with selection

Mon, 14 Jul 2014 10:54:07 GMT

GO to Properties of barchart and Select Detach May it helps to you.

Re: Bar chart should not effect with selection

lironbaram — Mon, 14 Jul 2014 10:54:27 GMT

you can use set analysis in the bar chart expression

if you want the bar chart to disregard all selection

just change the expression to sum({1} yourfieldname)

Re: Bar chart should not effect with selection

sudeepkm — Mon, 14 Jul 2014 10:56:04 GMT

in your bar chart you can modify the expression like below.

sum({<Month=>} Sales). any selection of Month in straight table or any where in the dashboard will not change the bar chart values.

Re: Bar chart should not effect with selection

polisetti — Mon, 14 Jul 2014 11:22:08 GMT

Hi,

Thanks for you immediate reply.

Please check the screenshot, so i want to show in same visualization.

When the bar is selected the particular data should show in straight table and the particular bar should come in different color.

Thanks

Polisetti

Re: Bar chart should not effect with selection

sujeetsingh — Mon, 14 Jul 2014 11:25:28 GMT

use set analysis

Re: Bar chart should not effect with selection

sujeetsingh — Mon, 14 Jul 2014 11:26:30 GMT

Poli,

Just use expression to change bar colour when the dimension get selection

Re: Bar chart should not effect with selection

polisetti — Mon, 14 Jul 2014 11:27:50 GMT

Can you please give me any example or sample qvw.

Thanks

Re: Bar chart should not effect with selection

sujeetsingh — Mon, 14 Jul 2014 11:34:37 GMT

See this sample

Re: Bar chart should not effect with selection

sudeepkm — Mon, 14 Jul 2014 11:34:41 GMT

Please take a look at the example.