topic Re: Group By Clause in QlikView

Group By Clause

nikhilgarg — Thu, 05 Mar 2015 11:19:00 GMT

Hey,

I ahve 2 tables. I want to have count on one column of 1st table but i have to put GroupBy function on columns in Second table.

How can we do this??

Thanks

Re: Group By Clause

PrashantSangle — Thu, 05 Mar 2015 11:21:57 GMT

Hi,

Can you explain with example??

Regards

Re: Group By Clause

nikhilgarg — Thu, 05 Mar 2015 11:25:17 GMT

I have table1 :

Item1 , Item2 , Item3

Table 2:

ITem4,

Item5;

I want to have count(Item1) group by item4 , item5 ?

Re: Group By Clause

Thu, 05 Mar 2015 11:26:33 GMT

You can to JOIN tables in script using JOIN keyword, as a result you will and up 1 table.

If you still want to keep both tables, Maybe you can JOIN them in a temp table and bring back the aggregated value to one of the table by ApplyMap or another Join

Re: Group By Clause

Thu, 05 Mar 2015 11:27:34 GMT

Don't they have any common field ?

Re: Group By Clause

nikhilgarg — Thu, 05 Mar 2015 11:29:11 GMT

Nope

Re: Group By Clause

richard_chilvers — Thu, 05 Mar 2015 11:39:26 GMT

I think they must have a common field otherwise your count will be meaningless.

If you can't share data with us, perhaps you can use sensible field names instead of Item 1 etc., so that we can help you.

Re: Group By Clause

PrashantSangle — Thu, 05 Mar 2015 11:43:05 GMT

Hi,

can i know how do you do this manually??

Please post sample data with required output.

Regards,

Re: Group By Clause

nikhilgarg — Thu, 05 Mar 2015 12:37:57 GMT

Hey,

ALso i would like to know that, In pivot table ia hve 3 dimensions and 1 expression as COunt(Item). Now i want to execute same by sql query.

So in sql query do i have to use group by including all the dimensions that ahve been used??

Re: Group By Clause

richard_chilvers — Thu, 05 Mar 2015 15:28:24 GMT

Well, perhaps we can get the COUNT working first and then you can decide how best to use it.

I suspect your dimensions are the common fields you need to join your tables ?