Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

homersimpson
Contributor III

I want 2 different names for the same field to call each field

Hi,

i have a field like "Products". I put it in the dashboard 2 times. I have 2 charts, chart A should react of the selection from the 1st Products field and chart B should react of the selection from the 2nd Products field.

I think i need 2 different names for the Products fields, so that i can call in the chart expression each field.

Is it possible?

regards,

Sam

8 Replies
antoniotiman
Honored Contributor III

Re: I want 2 different names for the same field to call each field

Hi,

may be

Chart A

Dimension : Product

Expression :Sum({<Product={'$(=MinString(Product))'}>} Value)

Chart B

Dimension : Product

Expression :Sum({<Product={'$(=MaxString(Product))'}>} Value)

and check 'Suppress 0 Value'

Regards,

Antonio

Re: I want 2 different names for the same field to call each field

May be like this:

Chart 1: React to selection in ProductField1 and Ignore ProductField2

Sum({<ProductField2>}Measure)

or

Sum({1<ProductField1 = $:Smiley TongueroductField1>}Measure)

Chart 2: React to selection in ProductField2 and Ignore ProductField1

Sum({<ProductField1>}Measure)

or

Sum({1<ProductField2 = $:Smiley TongueroductField2>}Measure)

homersimpson
Contributor III

Re: I want 2 different names for the same field to call each field

Mhh, i believe that´s not the solution or i don´t understand it. In the attachment i can show an example. I want to make two different selections and show the result in 2 different charts in one dashboard.

regards,

Sam

Re: I want 2 different names for the same field to call each field

Both the filter boxes are using the same field, is that right or is that by mistake?

homersimpson
Contributor III

Re: I want 2 different names for the same field to call each field

But the field Products have the same name so i can´t ProductField2 and ProductField1. Or can i say something like

Products['title']? Than i can use different title for each Products field...

homersimpson
Contributor III

Re: I want 2 different names for the same field to call each field

That´s right...

sfatoux72
Valued Contributor

Re: I want 2 different names for the same field to call each field

‌You should  use Alternate State (se Qlick Help : Alternate States ‒ QlikView)

sfatoux72
Valued Contributor

Re: I want 2 different names for the same field to call each field

Sorry, I just see now that the question was for Qlik Sense  ==> So, no Alernate State