Discussion board where members can get started with QlikView.
I want to do this on a pivot table
Count = 1,2
Score = A, B
Concat score and Count to become like this:
on a cell in pivot table.
Currently my set expression is
Concat(DISTINCT Score & Count, ',')
Appreciate any help. please don't send qlikview files and type in the example instead. thanks.
If you only want to concat values you can try this:
LOAD Distinct Score&'-'&Count as NewFeild,* INLINE [Count, Score1, A2, B];
Or write this as an expression Score&'-'&Count in your Pivot Table loading Score and Count dimensions
Post more data that you are trying to load