Different fields count in one table

Fri, 09 Aug 2013 00:10:44 GMT

Hi guys.

I build these two tables and I want to integrate the values, by month, from the second table into the first table, using something like the last expression (in red, not working).

Var 1(a date field) has a much lower count than Var 2 (a string field with full month names).

Is this possible? Could anyone suggest a working formula?

Thank you very much for your time.

Kind regards,

Nuno

Var1 ->	Jul-2013	Aug-2013	Sep-2013	Oct-2013	Nov-2013	Dec-2013	Jan-2014	Feb-2014	Mar-2014	Apr-2014	May-2014	Jun-2014
Expression 1	123	248	217	32	4	4	3	5	6	9	7	6
Expression 2	0	60	23	1	0	0	0	0	0	1	0	0
Expression 3	0	4	0	1	0	0	0	0	0	0	0	0
Expression 4	3	0	0	0	0	0	0	0	0	0	0	0
=count(total if(left(Var2,3)=month(avg(Var1)), Id))	-	-	-	-	-	-	-	-	-	-	-	-

left(Var2,3) ->	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
= count(Var2)	2289	2103	2642	2390	2162	2227	2176	2336	2662	2123	1877	1499

Re: Different fields count in one table

Gysbert_Wassenaar — Sat, 10 Aug 2013 18:26:51 GMT

Please read this document:

Preparing examples for Upload - Reduction and Data Scrambling

topic Different fields count in one table in QlikView

Different fields count in one table

Re: Different fields count in one table