Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Hi Koushik,
Try this
http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx
Hope it helps you.
Regards,
Jagan.
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.
Hi Koushik,
If you have the link between the two tables then use below expression
=Sum( Aggr(If(DATE1=DATE2, 1), ID))
Regards,
Jagan.
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
Hi,
May be check with this
Count({<DATE1=P(DATE2)>} ID)