Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi comunity,
I'm new here, an also new on qlik, after fiew searchs, i find that this forum can be very helpfull.
I have an problem with the presentation of a straight table, i explain : i have a table with various dimesensions that i want to group by types Thx you
try this way,
1.from dimensions tab click on "Addcalculatedimension button"--past this =purgechar(CI1,'12')
2. add ur CI 1 as second diemnion
3.expression tab use sum(value field)
or, if your group is always the first character of [CI 1]
left([CI 1], 1)
Thanks everybody, i try your solution but it seem that i miss something, so here the exact straight table and the
result i get when i put left(...) or purgechar(...) on the calculated dimension script. thnx u guys