Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to group table dimension

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 qlik.PNG

3 Replies
buzzy996
Master II
Master II

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)

maxgro
MVP
MVP

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

left([CI 1], 1)

Not applicable
Author

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

Capture.PNG