Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
saso_1970
Creator
Creator

How to filter by 2 dimension same dataset

Hi to all i need solution for this kind of problem I have dataset like on example 1

example1

   

NumberDescriptionSales
20Description 110
30Description 220
40Description 330
60Description 431
70Description 532
80Description 633
95Description 734
100Description 835
110Description 936
115Description 1037
120Description 1138
170Description 1239
180Description 1340
190Description 1441
200Description 1542
210Description 1643
220Description 1744
225Description 1845
240Description 1946
250Description 2047
255Description 2148
265Description 2249
280Description 2350
300Description 2451
310Description 2552
320Description 2653
330Description 2754
350Description 2855

I will like to separate in straight table numbers from 20 until 200 in one column and in second column from 210 until 350

like on example(the first 2 column are dimensions)

     

NumberDescriptionSalesNumberDescriptionSales
20Description 110210Description 1643
30Description 220220Description 1744
40Description 330225Description 1845
60Description 431240Description 1946
70Description 532250Description 2047
80Description 633255Description 2148
95Description 734265Description 2249
100Description 835280Description 2350
110Description 936300Description 2451
115Description 1037310Description 2552
120Description 1138320Description 2653
170Description 1239330Description 2754
180Description 1340350Description 2855
190Description 1441
200Description 1542

Thank you

0 Replies