Grouping data

[Baldaia]

Good afternoon,

I'm want to make Qlik group data that have the same value in a same column so i can aplly at each of this new cattegory an if. 

If i could make the if to recognise each of this group of data as a diffent thing to be analised wolud work too

Here where i came so far:

I Separated a name into diferents cattegorys:

OAD
Endereço,
SubField([Endereço],'-',1) as Quadra,
SubField([Endereço],'-',2) as Posição,
SubField([Endereço],'-',3) as Lastro,
SubField([Endereço],'-',4) as Altura,
Combinação
FROM [lib://Portnave/Simulação container.xlsx]
(ooxml, embedded labels, table is Planilha1);
Store Planilha1 into 'lib://Portnave/teste.qvd' (qvd);

In "posição" the data can be an 59 or a 60, i neet then to be seppareted. thanks

[rwunderlich · Accepted solution]

It seems you've already done the work.  For example, if you use "posição" as chart dimension, you will get separate rows for 59 and 60.

If you wanted to select just one specific value, you could use set expressions like:

count({<Posição={60}>}Endereço)

-Rob