topic Not Match Issue in App Development

Not Match Issue

erric3210 — Wed, 23 Mar 2022 15:19:58 GMT

Hi All,

I've a requirement to exclude Years from the Chart.

Although, my actual logic is very complex which I'm using in my Application but I created a sample to take help from you guys.

Here is the sample data:

LOAD * INLINE [
Year_Name, Flag
2022-02, NA
2022-01, NA
2021-12, NA
2021-11, NA
2021-10, NA
2021-09, A
2021-08, A
2021-07, A
2021-06, A
2021-05, A
];

Anyhow, I've to use concat in match condition in order to achieve the result but it's not working in my case.

I think I have to aggregate my expression again with using Concat & Aggr.

PFB the desired output snapshot:

Regards,

Eric

Re: Not Match Issue

rwunderlich — Wed, 23 Mar 2022 15:37:29 GMT

How about:

Only({<Flag={'A'}>} Year_Name)

-Rob

Re: Not Match Issue

Sivapriya_d — Wed, 23 Mar 2022 16:29:12 GMT

if there will be other values for Flag , you can try this
If(Flag<>'NA',Year_Name)

Re: Not Match Issue

erric3210 — Wed, 23 Mar 2022 18:17:39 GMT

Hi Sir,

Thanks for taking time and answering to my question.

But as I said above my actual logic is bit complex so,

I want t to generate result using something like this which are not matching:

=IF(NOT MATCH(Year_Name,CONCAT({<Flag={'NA'}>}CHR(39)&Year_Name&CHR(39),',')),Year_Name)

Hope I added some clarity here.

-Eric

Re: Not Match Issue

MarcoWedel — Wed, 23 Mar 2022 20:18:36 GMT

I think the trick to get your expression to work like you seem to expect would be to let the concat() function not only create a single string that is compared against the Year_Name values, but instead let it define the distinct match values itself. This can be done by dollar sign expanding the concat expression:

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/dollar-sign-expansion-using-expression.htm

I.e. in your case like this:

=IF(NOT MATCH(Year_Name,$(=CONCAT({<Flag={'NA'}>}CHR(39)&Year_Name&CHR(39),','))),Year_Name)

That being said, I do agree with Rob in that there surely are shorter, easier and faster (set expression) solutions than this, however complex your use case might be.

hope this helps

Marco

Re: Not Match Issue

erric3210 — Wed, 23 Mar 2022 20:55:37 GMT

Thanks @MarcoWedel for the solution.

Indeed it was a great learning for me.

- Eric.

Re: Not Match Issue

erric3210 — Wed, 23 Mar 2022 20:58:45 GMT

Hi @MarcoWedel

I agree that @rwunderlich logic is shorter and easier but I guess it will not work in my case.

My requirement is to exclude cases which is inside Concat() function.

- Eric