Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a stupid question i think but here it goes:
The following SET ANALYSIS counts the IDs where name is either test OR test2.
I am wondering if there is a way to achieve that only the IDs are counted where name is test AND test2.
I know i could solve that problem somehow via the data script but i was hoping to do it with SA.
Thanks a lot.
Count
(
{
$<
[Name] = {'test', 'test2'}
>
}
ID
)
I think it's
Count({ <ID=P({<Name={'test'}>})> * <ID=P({<Name={'test2'}>})> } ID)
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
Hi @schmidtj !
How is possible the field name have "test" AND 'test2' value??
I think what you trying to do is impossible.
Hi,
well ok i dont mean the name of the field i mean the value of the field 'Name'.
It is basically a 1:n relation so 'Name' can have multiple values.
I think it's
Count({ <ID=P({<Name={'test'}>})> * <ID=P({<Name={'test2'}>})> } ID)
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
Great, thanks working, thanks a lot!