How to satisfy the two condition in one single statement

[Karim_Khan]

Hi Team,

     I am facing one problem while trying to satisfy the two condition in one single Graph presentation.Is this possible to achieve the same in qlikview?

My Expression is as below.

=sum({1<[Entry Pages]={$(vEntry)}>} Visits)

The variable is saving the value as

vEntry=Concat(DISTINCT chr(39)& [Entry Pages] & chr(39),',')

If I select the Industry [AEC Industry],Program Name [AEC Infrastructure],Campaign Name [Project Jerry 2.0] then all the associated value get the correct data and showing the graph value correctly for Graph [Next Visits page] but when i am trying to select the activity type then the  value of Graph [Program Visit] doesn't change.It should change on the selection of Activity Type?

Regards,

KK

MRKachhiaIMP‌jagan‌gwassenaar‌Kush141087‌ashfaq_haseeb‌

[marcus_sommer]

Try it with single-quotes around the variable: sum({1<[Entry Pages]={'$(vEntry)'}>} Visits)

- Marcus

[sunny_talwar]

Why not this:

=Sum({1<[Entry Pages]=p([Entry Pages])}>} Visits)

[Karim_Khan]

Hi Its not working

=sum({1<[Entry Pages]=p([Entry Pages])>} Visits)

values are not getting changed on the selection of activity Type

[Karim_Khan]

Its not working

[sunny_talwar]

Try this:

=Sum({1<[Entry Pages]=p([Entry Pages])}, [activity type] = p([activity type])>} Visits)

[teiswamsler]

Hi Karim

To evaluate the varible put the expression into a text box like this:

=' sum({1<[Entry Pages]={=$(vEntry)}>} Visits) '

When you get the correct value you are after, copy the expression into the chart.

If not, try correcting the formula.

/Teis

[MK_QSL]

=sum({<[(v0) Program Name] =,  [Entry Pages]={$(vEntry)}>} Visits)

[Karim_Khan]

Hi Teis the expression

=' sum({1<[Entry Pages]={=$(vEntry)}>} Visits) '

is already working but my requirement is different

[Karim_Khan]

Hi Manish,

your expression

=sum({<[(v0) Program Name] =,  [Entry Pages]={$(vEntry)}>} Visits)

Your expression is working only for selected activity type but my requirement is that first its show the total visits value

and when I select the Activity Type then value should get change