Set Analysis - Association between two table creating issues

[#1]

Hi All,

I am new to Qlikview.

I am using below statement for Set Analysis.

=sum({ <[Report Month]={"<$(=[Report Month])"} > }[Review]

I have below two table which are Associated with field "Report Month".

Table1

ReportMonth     Product    Review

Jan-2014           ABC         1

Feb-2014           ABC         0

Mar-2014           ABC         1

Table2

ReportMonth   ProductCatogory

Jan-2014           Consumer

Feb-2014           Consumer

Mar-2014           Consumer

Apr-2014           Consumer

here, ReportMonth is common in both table

and also we need to associate this two table for some other reason.

but, here, problem is that,

we are using field Reportmonth in set analysis which is associated from two table,

so, i believed,

we are getting some duplicated records.

is there any way in set analysis,

to explicitly considered ReportMonth from Table1 Only ?

any help is appreciated.

Thanks!. 

[#2]

Joe,

I have attached sample file for this issue in the main thread.

can you please look in that and let me know ?

Thanks!.

[#3]

Manish,

I have attached sample file for this issue in the main thread.

can you please look in that and let me know ?

Thanks!.

[#4]

Hi Hailey,

the set analysis in that example looks to be working to me, unless you are wanting to include the current selected month plus previous?

In that case your expression is missing an equals sign

=sum({<[Month] = {'<=$(=Max([Month]))'}>}[Review?])

Edit: It also doesn't have the two tables as described in your question, but hopefully the above helps

[#5]

Thanks for your Reply Joe.

Actually,

below is my requirment.

Example :

Curretnly,

if we select Jul-2014 for C865B it shows all the records from previous month.

we want,

if we select Jul-2014 for C865B it should show current month record and

do Sum of review from all prior months.

make sense ?

[MK_QSL]

Can you provide the sample data also? need to check...

[#7]

Manish, I did not get you.

I have explained criteria to Joe.

does that make sense ?

[#8]

Hi Hailey,

The above expression will do what you want then I believe, just need "<=" rather than the "<"

[#9]

Joe,

it's returning multiple records more than one ,

in example month - July 2014.

it should return one record for selected month.

[#10]

That's because you have the month dimension in there, if you take that out it will give you all the months total if that is what you are after

Joe