topic Re: Display ID and Name instead of the ID count column in App Development

Display ID and Name instead of the ID count column

24_02_SRR — Fri, 15 Nov 2024 21:53:36 GMT

Hi All,

We have one column called Count of ID in Pivot table, but the end-user wants to display the ID&'-'&Name instead of the ID count.

Ex:

Count({<Level={'L1'}>}ID)

How do we get that in ID&Name in measure column

BrunPierre — Mon, 17 Apr 2023 15:49:52 GMT

Can you elaborate?

24_02_SRR — Mon, 17 Apr 2023 16:52:39 GMT

We are displaying ID count as one column. instead of the count column they want to see the actual Employee ID and Name

Ex: Count value is 4 means, they want to see the who are the 4 members

BrunPierre — Mon, 17 Apr 2023 18:40:06 GMT

Add this in the load script,

ID & '-' & Name as "ID_NAME"

and this for the expression

=Concat(DISTINCT {$<ID_NAME={"=Count({<Level={'L1'}>} ID) > 0"}>} ID_NAME,' ,')

24_02_SRR — Mon, 17 Apr 2023 18:19:53 GMT

I'm getting blank column for this measure.

BrunPierre — Mon, 17 Apr 2023 18:41:19 GMT

Retry

=Concat(DISTINCT {$<ID_NAME={"=Count({<Level={'L1'}>} ID) > 0"}>} ID_NAME,' ,')

24_02_SRR — Mon, 17 Apr 2023 18:51:49 GMT

Thanks for your help. It's working but I'm getting result like 153-AAA,145-BBB,167-CCC

but I want

153-AAA

145-BBB

167-CCC

which means Space or line space. Is there any function to create line level space

BrunPierre — Mon, 17 Apr 2023 19:10:37 GMT

Tmp:
LOAD * ,
ID & '-' & Name as "ID_NAME"
Inline [
Programs,Level,ID,Name
A,L1,153,AAA
A,L1,145,BBB
A,L1,167,CCC
B,L1,187,DDD
B,L1,145,BBB];

NoConcatenate
LOAD Programs,
Level,
MaxString(ID_NAME) as ID_NAME

Resident Tmp

Group By Programs, Level, ID;

DROP Table Tmp;

EXIT SCRIPT;

24_02_SRR — Tue, 18 Apr 2023 02:03:40 GMT

Thanks for your immediate replies