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‌

[MK_QSL]

You can use two expressions

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

with Conditional show GetSelectedCount([(v0) Activity Type])=0

and

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

with Conditional show GetSelectedCount([(v0) Activity Type])<>0

[Karim_Khan]

Hi Sir,

When I am using First Condition then its giving me the Total Visits correctly but when I click on Activity Type then Graph value gets hide automatically

I wanted to show the value if we select the type of Activtity

Regards,

KK

[MK_QSL · Accepted solution]

Check !

[Karim_Khan]

I got it sir thank you so much sir.

But for showing the number we have to pass the expression in filters also?or is there some other way to achieve the same.

[sasiparupudi1]

Hi MRKachhiaIMP

Just want to understand,why cant we use a single expression like the following

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

Thanks

Sasi

[Karim_Khan]

Sir values are getting double