topic Set Analysis with an expression in QlikView

Set Analysis with an expression

paul_ripley — Tue, 22 Sep 2015 16:00:54 GMT

Hello

I have some data and I would like to limit the entities and account codes within that data that are brought back.

An example of a basic expression on my data which works is

sum ( { <account = {'1101'}, Entity = {'0415'}> } gl_amount)

What I really want is to show all 1* accounts and all entities either <'0900' or <'A0900'

I tried using wildmatch for the account and failed and also not sure how to limit the entities

any help would be appreciated

Thanks

Paul

pokassov — Tue, 22 Sep 2015 16:06:56 GMT

Something like this?

sum ( {$<account = {'=1*'}, Entity = {'<*0900'}>} gl_amount)

jolivares — Tue, 22 Sep 2015 16:20:11 GMT

You must user "

sum ( {$<account = {'=1*'}, Entity = {"<0900"}+ {"<A0900"}>} gl_amount)

stigchel — Tue, 22 Sep 2015 16:31:29 GMT

Think the <*0900 or <A0900 do not work? Maybe something like

sum ( {$<account = {"=1*"}, Entity = {"=Keepchar(Entity,'0123456789')<900"}>} gl_amount)

sunny_talwar — Tue, 22 Sep 2015 17:04:38 GMT

Can you share some sample data to check out how exactly the data look?

paul_ripley — Wed, 23 Sep 2015 10:40:51 GMT

Hi All

Thanks for your help

I couldn't get it to work but it is possibly my data so I will continue to investigate

Kind regards

Paul