topic Re: make group for records in QlikView

make group for records

Anonymous — Tue, 10 Nov 2015 11:24:53 GMT

if I have TABLE01 contain (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19) and i want to make table02 contain (A,B,C,D). so when I select A in table02 it should show me (1,2,3,4,5) in table01, and when I select B in table02 it should show me (6,7,8,9,10)..

if the example is not clearly, i will put live example.qvs

Re: make group for records

sunny_talwar — Tue, 10 Nov 2015 11:28:06 GMT

Is TABLE01 a column here???

May be this;

LOAD TABLE01,

If(TABLE01 < 6, 'A',

If(TABLE01 < 11, 'B',

If(TABLE01 < 16, 'C', 'D'))) as TABLE02

FROM Source

Re: make group for records

Kushal_Chawda — Tue, 10 Nov 2015 11:36:01 GMT

It's confusing. TABLE01 is the field or table?

Re: make group for records

Anonymous — Tue, 10 Nov 2015 11:44:27 GMT

i have this table SEGMENT2 and i want to make group for this numbers so each number start with 10 = salaries, 11 = depreciation.. so when i select salaries i want to show breakdown list with all number start with 10

Re: make group for records

Mark_Little — Tue, 10 Nov 2015 11:48:48 GMT

Hi,

If(LEFT(SEGMENT2,2) = 10, 'salaries',

If(LEFT(SEGMENT2,2) = 11, 'depreciation')

... // Other groupings

) AS Grouping

Should give you this grouping,

Mark

Re: make group for records

sunny_talwar — Tue, 10 Nov 2015 11:53:48 GMT

Or this:

Pick(WildMatch(SEGMENT2, '10*', '11*', and so on), 'Salaries', 'Depreciation') as Group