Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis syntax query

Hi

Just started using set analysis and looks like I got the syntax wrong.

Aggr(Count({<dim1=dim2, dim3>}),dim2)

Can I get some help on this please.

1 Solution

Accepted Solutions
Not applicable
Author

You aggregate data by dim2. So, what do you do after? Sum? Avg?

Sum( Aggr(Count({<dim1=dim2, dim3 >}),dim2))

And what want you do with dim3. This need any value for comparison.

Regards,

Ricardo

View solution in original post

6 Replies
Not applicable
Author

You aggregate data by dim2. So, what do you do after? Sum? Avg?

Sum( Aggr(Count({<dim1=dim2, dim3 >}),dim2))

And what want you do with dim3. This need any value for comparison.

Regards,

Ricardo

jagan
Partner - Champion III
Partner - Champion III

Not applicable
Author

I have two tables with DATE1 and ID as column names. Calendar is controlled by DATE1. In the secomd table I have DATE2 and DATE3. I am after creating a Bar-Line chart where

BAR - Count of ID

Line - Count ID where Date1 = DATE2

I cant join the two tables due to dependincies.

I hope i answer your question.

jagan
Partner - Champion III
Partner - Champion III

Hi Koushik,

If you have the link between the two tables then use below expression

=Sum( Aggr(If(DATE1=DATE2, 1), ID))

Regards,

Jagan.

Not applicable
Author

There is no link between the tables. As much as I want to link, I cant as it reflects data in the other tabs. Is there a way without linking the dates (DATE2, DATE3) to change when year or month is selected form the calendar defined by DATE1

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

May be check with this

Count({<DATE1=P(DATE2)>} ID)