Discussion board where members can get started with Qlik Sense.
I have a requirement to get the contract only those having more than one Asset
11 Asset 111 Asset 222 Asset 133 360p44 Asset 144 3037PS
Thanks in advance,
Try to use that as dimension =If(Aggr(Count(Asset),Contract)>1,Contract) and suppress null maybe
View solution in original post
maybe you could try in this way
LOADContractWhere Count>1;LoadContract,Count(Asset) as Count
From ...Group ByContract;
Thanks for your reply.Can you suggest something on frontend using set analysis or something coz the datamodel is a bit complicated.
Thanks for your solution . It worked. Can you tell if possible how to get the count of it .In this case it's 2.
You could use Count(Asset) because in this way data are filtered by dimension
If in a KPI ,I want to show?