Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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