Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
MEBG93
New Contributor III

Is there a way to insert an 'OR' condition in a 'Group by' statement?

Hello!

I was wondering if there is a way to insert an 'OR' statement in a 'Group by' statement.

E.g.

load * inline [

name, location, team

a, london, red

b, london, green

c, manchester, red

d, london, blue]

group by

team = 'red'

or

team='blue';

 

Thanks!

Labels (3)
2 Replies
Highlighted
naumanshah
New Contributor III

Re: Is there a way to insert an 'OR' condition in a 'Group by' statement?

'Group by' is typically used in conjunction with aggregation functions like SUM/AVG etc. When you are using load * inline then you don't need to group by the data.

Re: Is there a way to insert an 'OR' condition in a 'Group by' statement?

What output are you looking to see?