topic Re: By Selecting one chart the other should not get changed in QlikView

By Selecting one chart the other should not get changed

kunkumnaveen — Tue, 31 Jul 2018 11:28:23 GMT

Hello All,

I got two pie charts

First Chart

Dimension:Management

Expression:

Count({<[CRITERIA]={'MANAGEMENT'},Funding=>}distinct Supplier)

Second Chart

Dimension:Funding

Expression:

Count({<[CRITERIA]={'FUNDING'},Management=>}distinct Supplier)

My requirement is either chart Dimension is selected the other chart should remain unchanged

but it not happening in my case even though i disable the selection in set analysis

I tried by using 1 in the set analysis of both the chart as below

Count({1<[CRITERIA]={'MANAGEMENT'},Funding=>}distinct Supplier)

Count({1<[CRITERIA]={'FUNDING'},Management=>}distinct Supplier)

but if i use 1 in the set analysis, even the selected chart remains unchanged,which is wrong ,

My requirement is selected chart should change the rest should remain unchanged

Thanks

sunny_talwar — Tue, 31 Jul 2018 11:37:20 GMT

I see that your filter selection is showing =Management, instead of just Management as a field... is this a calculated dimension or something?

kunkumnaveen — Tue, 31 Jul 2018 11:50:26 GMT

I Have done this at backend

[ SCORES]:

load *,

if(SRMM_Criteria_Color='RED-MANAGEMENT',' ',if(SRMM_Criteria_Color='GREEN-MANAGEMENT',' ')) as Management,

sunny_talwar — Tue, 31 Jul 2018 11:57:17 GMT

and are you using Management as a dimension? Can you make sure to remove the equal sign from the chart dimension?

kunkumnaveen — Tue, 31 Jul 2018 12:01:15 GMT

I think ,the issue is because of that = sign

sunny_talwar — Tue, 31 Jul 2018 12:02:16 GMT

Yup, I think so too