topic Re: Match values in QlikView

Match values

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

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

Re: Match values

m_woolf — Tue, 16 Oct 2018 14:37:40 GMT

For the dimension try:

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

Re: Match values

manu1512 — Tue, 16 Oct 2018 14:50:19 GMT

Thanks for reply but is not working

Re: Match values

sudeepkm — Tue, 16 Oct 2018 15:03:04 GMT

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.

Re: Match values

m_woolf — Tue, 16 Oct 2018 16:00:56 GMT

Can you post a sample qvw?

Re: Match values

kenkuchana — Tue, 16 Oct 2018 16:31:10 GMT

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

Re: Match values

Zhandos_Shotan — Tue, 16 Oct 2018 18:31:41 GMT

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/SetAnalysis/set-modifier…

For better answer, please give a some example?