Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
MRKachhiaIMPjagangwassenaarKush141087ashfaq_haseeb
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
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
Check !
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.
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
Sir values are getting double