topic Re: How to satisfy the two condition in one single statement in QlikView

How to satisfy the two condition in one single statement

Karim_Khan — Thu, 10 Sep 2015 10:24:29 GMT

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,

MRKachhiaIMP‌jagan‌gwassenaar‌Kush141087‌ashfaq_haseeb‌

Re: How to satisfy the two condition in one single statement

marcus_sommer — Thu, 10 Sep 2015 10:29:59 GMT

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

- Marcus

Re: How to satisfy the two condition in one single statement

sunny_talwar — Thu, 10 Sep 2015 10:31:20 GMT

Why not this:

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

Re: How to satisfy the two condition in one single statement

Karim_Khan — Thu, 10 Sep 2015 10:48:55 GMT

Hi Its not working

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

values are not getting changed on the selection of activity Type

Re: How to satisfy the two condition in one single statement

Karim_Khan — Thu, 10 Sep 2015 10:49:48 GMT

Its not working

Re: How to satisfy the two condition in one single statement

sunny_talwar — Thu, 10 Sep 2015 10:52:36 GMT

Try this:

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

Re: How to satisfy the two condition in one single statement

teiswamsler — Thu, 10 Sep 2015 10:57:47 GMT

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

Re: How to satisfy the two condition in one single statement

MK_QSL — Thu, 10 Sep 2015 10:57:51 GMT

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

Re: How to satisfy the two condition in one single statement

Karim_Khan — Thu, 10 Sep 2015 11:05:17 GMT

Hi Teis the expression

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

is already working but my requirement is different

Re: How to satisfy the two condition in one single statement

Karim_Khan — Thu, 10 Sep 2015 11:10:01 GMT

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

Re: How to satisfy the two condition in one single statement

MK_QSL — Thu, 10 Sep 2015 11:23:56 GMT

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

Re: How to satisfy the two condition in one single statement

Karim_Khan — Thu, 10 Sep 2015 11:42:08 GMT

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,

Re: How to satisfy the two condition in one single statement

MK_QSL — Thu, 10 Sep 2015 11:43:18 GMT

Check !

Re: How to satisfy the two condition in one single statement

Karim_Khan — Thu, 10 Sep 2015 11:51:12 GMT

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.

Re: How to satisfy the two condition in one single statement

sasiparupudi1 — Thu, 10 Sep 2015 12:20:26 GMT

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

Re: How to satisfy the two condition in one single statement

Karim_Khan — Thu, 10 Sep 2015 12:25:40 GMT

Sir values are getting double