topic Re: How to group table dimension in QlikView

How to group table dimension

Wed, 03 Jun 2015 09:49:49 GMT

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

Re: How to group table dimension

buzzy996 — Wed, 03 Jun 2015 15:59:31 GMT

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)

Re: How to group table dimension

maxgro — Wed, 03 Jun 2015 21:59:34 GMT

or, if your group is always the first character of [CI 1]

left([CI 1], 1)

Re: How to group table dimension

Thu, 04 Jun 2015 07:14:18 GMT

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