Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Classes within a class

Hello!

Is there any way to create classes within a class?

Tags (1)
13 Replies
MVP
MVP

Re: Classes within a class

Can you please detail your requirement?

In general, I would say yes, like hierarchical dimensions: Years can be broken down to Months, Days etc.

An Integer can be split into its tenth, its hundredth etc.

prabhu0505
Valued Contributor

Re: Classes within a class

Not possible.

balrajahlawat
Esteemed Contributor

Re: Classes within a class

You can Create, but what is the need of creating interval again of already created interval??

=class(Class(Temp,10),20)

You can do something like above, if you use inner class interval only it would create interval of 10 say 0-10,10-20 like this

If you use Class within Class it would give you 0-20,20-40 like this..

Not applicable

Re: Classes within a class

I want to create this tree for which I need to create classes within  a class. How can I do

that??

tree.png

krishna_2644
Valued Contributor III

Re: Classes within a class

provide some sample data with clear description of what you are trying to achieve.

Not applicable

Re: Classes within a class

I have a two variables month and blood group. I want to create a dimension of month in which I have two classes for month say CLASS 1 (includes first six months of the year) and CLASS 2 (includes last six months of the year). Then within the CLASS 1, I want to create two more classes of second variable "Blood Group" say BG1 (Includes blood group A+, B+) and BG2 ( including blood groups O+, AB+).

krishna_2644
Valued Contributor III

Re: Classes within a class

Also Please provide some sample data(the heirarchical data ) so that i can play around with it and get back to u with a solution.

Not applicable

Re: Classes within a class

   This is the data.

   

ResultBlood GroupMonth of Birth
3(60-75%)B+November
A+August
1(>90%)O+October
4(45-60%)A+November
3(60-75%)B+March
3(60-75%)O+July
3(60-75%)AB+January
1(>90%)O+February
2(75-90%) September
February
2(75-90%)B+July
2(75-90%)B+April
4(45-60%) April
4(45-60%) February
3(60-75%) August
4(45-60%) May
2(75-90%)B+January
1(>90%)AB+January
3(60-75%) April
2(75-90%)O+December
2(75-90%)O+August
2(75-90%) July
2(75-90%)AB+April
3(60-75%) October
4(45-60%)B+August
O+October
MVP
MVP

Re: Classes within a class

BG:

MAPPING LOAD * INLINE [

F1, F2

A+, BG1

B+, BG1

AB+, BG2

O+, BG2

];

MoB:

MAPPING LOAD * INLINE [

F1, F2

January, CLASS1

February, CLASS1

March, CLASS1

April,CLASS1

May,CLASS1

June,CLASS1

July,CLASS2

August,CLASS2

September,CLASS2

October,CLASS2

November,CLASS2

December, CLASS2

];

LOAD Result,

          [Blood Group],

          [Month of Birth],

          ApplyMap('BG', [Blood Group], 'BG map not found') as [Blood Group Class],

          ApplyMap('MoB', [Month of Birth], 'MoB map not found') as [Month of Birth Class]

FROM YourSources;