Conditional Dimension

[zelalemdatew]

Hi All

I am working on the a project that requires a conditional dimension. So I have two columns (A and B) I need to use for the chart. But, the issue is I want to group column B in 4 different category based on the count. Please see below:

a.       Less than 20

b.      Between 20 and 24

c.       Between 25 and 29

d.      Greater than 30

Can anyone help me writing this expression please?

Thanks in advance!

[ajaykakkar93]

Hi,

If(B <20 , 'less than 20'

,

If(B >=20 and B<=24,'20-24'

,

If(B >=25 and B<=29,'25-29'

,

If(B >=30,'greater than 30'))))

[ajaykakkar93]

Hi,

You can edit & paste this to your back-end final table

& Give a proper columns name to it 

Example:

Load *,

If(......) as brandGroup

Resedent table name;

[zelalemdatew]

Thanks for replying.

Sorry that I wasn't clear enough, but column B is not an integer right now it is string, which I have to count them first based on column A's usage. 

For instance I use your suggestions like: 

If(Count(B) <20 , 'less than 20'
,
If(Count(B) >=20 and Count(B)<=24,'20-24'
,
If(Count(B) >=25 and Count(B)<=29,'25-29'
,
If(Count(B) >=30,'greater than 30'))))

But doesn't seem to work.

I think it is because I am trying to use aggregate functions in Dimensions not in measure.

Thanks!

[ajaykakkar93]

Can you share a sample data I'll give u a proper code for this

[zelalemdatew]

I figured it out. I did all the condition in the back end instead of in Qlik. Thanks for the help though!