topic Set analysis and operator in QlikView

Set analysis and operator

sifatnabil — Mon, 13 Jun 2016 09:43:54 GMT

Hi all,

In a straight table, I have customer as dimension, and in expression I want to count how many weeks that a customer has participated on both Tuesday and Friday in any given week. I'm using this set analysis

=count({<WeekStart=p({<WeekDay={'Fri'}>})*p({<WeekDay={'Tue'}>})>}distinct WeekStart)

Is there something wrong with this set analysis? Because it's showing an incorrect number.

Re: Set analysis and operator

Kushal_Chawda — Mon, 13 Jun 2016 09:51:35 GMT

seems correct to me, try below

count({<WeekDay={'Fri'}>*<WeekDay={'Tue'}>} distinct WeekStart)

Re: Set analysis and operator

swuehl — Mon, 13 Jun 2016 09:51:57 GMT

You would need to bring in the customer in your set expression.

Create a key in your data model that is made of CustomerID and Weekstart, CustomerIDWeekstart.

=count({<CustomerIDWeekstart = p({<WeekDay={'Fri'}>})*p({<WeekDay={'Tue'}>})>} distinct CustomerIDWeekstart)

Re: Set analysis and operator

Anonymous — Mon, 13 Jun 2016 09:52:56 GMT

Hi Sifat, try this

=count({<WeekStart=p({<WeekDay={'Fri'}*{'Tue'}>})>}distinct WeekStart)

Regards