compare two date in set analysis

Tue, 20 Mar 2012 14:16:52 GMT

Hello all,

I have problem with comapring two date in set analysis. For example I have two table:

Tab1:

Load * inline [

date1, value1];

and

Tab2:

Load * inline [

date2, value2];

and now in pivot table I want to compare sum of value for that date, I mean: sum({<date2= date1>}value2) but it works only when I've set only one date. So then I try something like that: sum({<date2= {">=$(=min(date1))<=$(=max(date1))"}>}value2) but of course it shows one sum of value for many date. Have you got any idea how to solve it?? the problme is that It must be other table, so I can't concatenate tab1 and tab2 or join it. Please help me.

Re: compare two date in set analysis

lironbaram — Tue, 20 Mar 2012 14:36:46 GMT

hi check attah example

hope it helps you

Re: compare two date in set analysis

Thu, 22 Mar 2012 14:18:16 GMT

Yes, you are right, but here the problem is that I have many data, so I add set analysis and reduce some data. Thank you.

topic Re: compare two date in set analysis in QlikView

compare two date in set analysis

Re: compare two date in set analysis

Re: compare two date in set analysis