Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My data like
LOAD * Inline [
ID,NAME,TECHNOLOGY
100,A,Qlikview
200,B,Informatica
300,A,Qliksense
400,D,Java
500,D,Drupul
600,E,Qliksense
700,B,Oracle
];
like this i have 5000 rows of data i have .
here i need who are associated with multiple technologies.
Dim:-NAME,TECHNOLOGY
Exp:-Count(ID)
Exp O/P:-
NAME,TECHNOLOGY
A,Qlikview,
A,Qliksense,
D,Java,
D,Drupul,
B,Oracle,
B,Informatica,
how can i write calculation dimension in dimension level for this
Hi,
take table box
add Name & Technology.
Regards,
What do you want to achieve.
can you explain in details??
Regards,
Hi,
Your calculations should be something like
IF(Count(ID)>1,Name)
Mark
May be this?
Count({<NAME = {"=Count(TOTAL <NAME> ID)>1"}>} TOTAL <NAME> ID)
OR
Count({<NAME = {"=Count(TOTAL <NAME> ID)>1"}>} ID)
OR, This is dimension
=If(Aggr(Count({<NAME = {"=Count(TOTAL <NAME> ID)>1"}>} ID), NAME), NAME)
Make sure, To use Suppress for that
try like this in the expression that should also work
if(count(ID)>1,Count(ID))
in the dimension
if(Aggr(Count(ID),NAME)>1,NAME)
I tried all Conditions not working,
even
my condition is working in sample data =Aggr(if(count(NAME)>=2,NAME),NAME)
But not working in final table.
What you mean by final table? Seems working