Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Master III
Master III

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

sunny_talwar

May be like this:

Chart 1: React to selection in ProductField1 and Ignore ProductField2

Sum({<ProductField2>}Measure)

or

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

Chart 2: React to selection in ProductField2 and Ignore ProductField1

Sum({<ProductField1>}Measure)

or

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

Anonymous
Not applicable
Author

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

sunny_talwar

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

Anonymous
Not applicable
Author

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...

Anonymous
Not applicable
Author

That´s right...

sfatoux72
Partner - Specialist
Partner - Specialist

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

sfatoux72
Partner - Specialist
Partner - Specialist

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