topic Count with set analysis using another field in QlikView

Count with set analysis using another field

Anonymous — Thu, 12 Feb 2015 21:17:06 GMT

Hi,

I need to make a set analysis comparing 2 date fields inside on a set analysis operation, my actual expression it's something like this:

=count({$<Date1={>=Date2}, Type={'ReadOnly'}>} Event)

Its possible to restrict my set analysis to Date1 greater then Date 2 in this case?

Re: Count with set analysis using another field

Thu, 12 Feb 2015 21:44:45 GMT

Hi Gabriel,

You cannot have two datamodel fields in comparison in set modifies like Date1>=Date2. where Date1 and Date2 are fields in datamodel. You either have to create comma seperated values from Date2 possible values and then put it in set analysis to work or have static values like '01/01/2014' etc.

You can use concat function like

concat(distinct Date2, ',') and write this in set analysis using $ sign expansion.

=count({$<Date1={">=$(=concat(distinct Date2, ','))"}, Type={'ReadOnly'}>} Event)

Hope this helps,

Anosh

Re: Count with set analysis using another field

Thu, 12 Feb 2015 22:16:58 GMT

Not sure your exact requirements but assuming, date1 and date2 are static fields not selections, you may want to compare Date1 and Date2 in the load script and create a 3rd column like IsDate1GreaterThanDate2 and use it in your set analysis.