How to have force multiple line records into a single record or cell

[Daniel77]

HI,

I have a dimension which will change per year "Score Letter".

See below:

I would like to get this in a single line like below:

2022 Score	2023 Score	Standard NAme
c	c	Amfori BSCI

is this possible please?

thanks in advance.

Daniel

[RafaelBarrios]

Hi @Daniel77

the easy way is to create two measures

measure 1: only({< [Ex Date]={"*2022*"} >} [Internal Score Letter])

measure 2: only({< [Ex Date]={"*2023*"} >} [Internal Score Letter])

and by script you can try the opposite of crosstable, that is known as Generic Load

https://community.qlik.com/t5/Design/The-Generic-Load/ba-p/1473470

Hope this helps.

Best,

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 😁

[Daniel77]

Thank you so much and apologies for the late reply.

I will follow up and comment on the success of this asap.

Thank you