topic Re: How to restrict Field in chart having same values with different name fields in QlikView

How to restrict Field in chart having same values with different name fields

Lakshman_1031 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have one table and in that having duplicate field names like

Supply2 and Supply_chain having values like Asia,Gulf and States .

I have one chart and in that Supply2 having Dimension.

I want to restrict Supply_chain selection for that i have used

Sum({<Supply_Chain=>} Sales)

and

Sum({1<Supply_Chain = $::Supply_Chain>} Sales)

But it is not working Please suggest me how to avoid Supply chain selections in chart with out using alternative state, Because Supply_chain selections reflected in entire dashboard.

Please see the below example for your reference.

If possible please suggest me how to achieve this scenario.

Thanks & Regards,

lakshman

Re: How to restrict Field in chart having same values with different name fields

jonathandienst — Fri, 22 May 2020 10:17:38 GMT

I am not sure what you are trying to do here. The model looks OK, although I would prefer not to have two fields containing the same information.

If you want to limit Supply_Chain to match the values in Supply2:

{<Supply_Chain = P(Supply2)>}

Although this will do nothing if Supply2 and Supply_Chain are in the same data table.

Re: How to restrict Field in chart having same values with different name fields

Lakshman_1031 — Tue, 26 May 2020 04:57:08 GMT

Hi Jontydkpi,

Thanks for your replay.

I have tried {<Supply_Chain = P(Supply2)>} but it is not working.

My problem is if i select anything in supply_Chain it won't effect in bar chart and remaining filters will effect.

But i have used {<Supply_Chain = P(Supply2)> it is effected my chart.

please suggest me how to achieve this scenario.

Thanks & regards,

Lakshman

Re: How to restrict Field in chart having same values with different name fields

Lakshman_1031 — Tue, 26 May 2020 05:14:28 GMT

Hi Jontydkpi,

Thanks for your replay.

I have tried {<Supply_Chain = P(Supply2)>} but it is not working.

My problem is if i select anything in supply_Chain it won't effect in bar chart and remaining filters will effect.

But i have used {<Supply_Chain = P(Supply2)> it is effected my chart.
please suggest me how to achieve this scenario.

Thanks & regards,

Lakshman

Re: How to restrict Field in chart having same values with different name fields

tresB — Tue, 26 May 2020 07:10:01 GMT

Not really sure what you are looking for. Could you explain a bit more? What if you use expression:

Sum({<Supply_Chain=>} Sales) ?

Re: How to restrict Field in chart having same values with different name fields

Lakshman_1031 — Tue, 26 May 2020 08:04:12 GMT

Hi Tresesco,

I have one table in that having fileds like Supply2 field having values like Asia, Gulf, States and Supply_chain having Asia1, Gulf 1, States 1.

I have chart and in Dimension having Supply2.

I have filters like Supply 1,Supply 2 Category and Supply_Chain.

My problem is if i select Supply_chain it won't effect in bar chart and remaining objects will effect based on the Supply_Chain and other filter selections,

and bar chart will effect other filter selections except Supply_chain selections.

I tried in expression Sum({<Supply_Chain=>} Sales).

Please see the below example for your reference.

Please suggest me how to achieve this scenario.

Thanks & Regards,

Lakshman