topic Re: Set analysis syntax query in QlikView

Set analysis syntax query

Tue, 19 Mar 2013 15:18:32 GMT

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.

Re: Set analysis syntax query

Tue, 19 Mar 2013 15:22:57 GMT

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

Re: Set analysis syntax query

jagan — Tue, 19 Mar 2013 15:22:58 GMT

Hi Koushik,

Try this

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

Hope it helps you.

Regards,

Jagan.

Re: Set analysis syntax query

Tue, 19 Mar 2013 15:40:44 GMT

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.

Re: Set analysis syntax query

jagan — Tue, 19 Mar 2013 17:19:35 GMT

Hi Koushik,

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

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

Regards,

Jagan.

Re: Set analysis syntax query

Tue, 19 Mar 2013 17:23:08 GMT

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

Re: Set analysis syntax query

CELAMBARASAN — Tue, 19 Mar 2013 17:29:37 GMT

Hi,

May be check with this

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