How to convert condition to set analysis

[danilopvh]

Hi, I need to convert this formula into set analysis ... any help?

COUNT(IF(WildMatch(PRODUTO,'MADEIRA*') AND UF_ORIGEM<>UF_DESTINO, SEQ_ITEM_GUIA))

Thanks

Note. I'm Brazilian, my writing is not good. But my reading is very good.

[vamsee]

Hello,

Try this

COUNT({<Poruduto={'MADEIRA*'}, UF_ORIGEM-={'UF_DESTINO'}>}SEQ_ITEM_GUIA)

Thanks

[vamsee]

This is a very good document for Set Analysis.

Please have a look

Set Analysis: syntaxes, examples

[Ivan_Bozov · Accepted solution]

How about this:

Count({<PRODUTO={"MADEIRA*"}, UF_ORIGEM-={'UF_ORIGEM'}>}SEQ_ITEM_GUIA)

[Ivan_Bozov]

Hi, the search string should be in double quotes otherwise it will not work in new Qlik Sense versions. Check this out: Quotes in Set Analysis

[vamsee]

Thanks for that

[agigliotti]

You can add a flag in the script.  For example:

LOAD

...

WildMatch(PRODUTO,'MADEIRA*') as Flag

Resident YourTableName;

Then for the set analysis you can use:

COUNT( {< Flag = {'1'}, UF_ORIGEM -= {'UF_DESTINO'} >} SEQ_ITEM_GUIA )

Hope this helps.

[danilopvh]

It worked, thank you very much

[danilopvh]

It works too, thanks.

[vkish16161]

Count({<PRODUTO={"MADEIRA*"}, UF_ORIGEM  =-    {'UF_ORIGEM'}>}SEQ_ITEM_GUIA)