Match values

[manu1512]

Hi all,

I have two columns one is equipmentcountries and other is contract countries,both have some common values

In bar chart chart i want to display the countries which are common to both only using equipmentcountries  as a dimension ?

Please help?

Kind Regards

MANU

[m_woolf]

For the dimension try:

=if(index(concat(contract countries,','),equipmentcountries)>0,equipmentcountries)

[manu1512]

Thanks for reply but is not working

[sudeepkm]

May be you can better handle it in your script by comparing the equipmentcountries value to contract countries value per record and create a flag with values 1 or 0. Then in your Chart you can use the flag in the expression (set analysis) so that it would only display those Dimension values where it matches.

[m_woolf]

Can you post a sample qvw?

[kenkuchana]

In Dimension use "If(equipmentcountries = [contract countries], equipmentcountries, null())" and select suppress null values

[Zhandos_Shotan]

Hi!

You need to use P() in set modifier expression as set of field values using a nested set definition. %)

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetA...

For better answer, please give a some example?