Set analysis syntax query

[#1]

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.

[#2 · Accepted solution]

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]

Hi Koushik,

Try this

http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx

Hope it helps you.

Regards,

Jagan.

[#4]

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]

Hi Koushik,

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

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

Regards,

Jagan.

[#6]

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]

Hi,

May be check with this

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