topic Re: Set Analysis in QlikView

Set Analysis

evansabres — Wed, 02 Nov 2016 01:19:06 GMT

I have a line chart with one dimension (transDATE) and ten expressions. All of the expressions are the same except for one difference within the set analysis that is within the expression. (Example below)

=Min( {<capLEVEL={'200 Club Center'}>} transBASEPRICE)

What I would like to be able to do is to add another element to this expression I have another dimension called transBUYERTYPE. I would like to add into each expression an element that references this transBUYERTYPE (it would be equal to 'ADULT') I want to be able to tell the transBASEPRICE for the transBUYERTYPE of 'ADULT' on each transDATE.

Is this possible?

Re: Set Analysis

Wed, 02 Nov 2016 01:23:50 GMT

Hi Evan,

Are you trying to implement this?

=Min(

capLEVEL={'200 Club Center'},

transBUYERTYPE={'ADULT'}

transBASEPRICE)

Re: Set Analysis

sunny_talwar — Wed, 02 Nov 2016 01:37:15 GMT

May be like this:

=Min( {<capLEVEL={'200 Club Center'}, transBUYERTYPE = {'ADULT'}>} transBASEPRICE)