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
Check !
Try it with single-quotes around the variable: sum({1<[Entry Pages]={'$(vEntry)'}>} Visits)
- Marcus
Why not this:
=Sum({1<[Entry Pages]=p([Entry Pages])}>} Visits)
Hi Its not working
=sum({1<[Entry Pages]=p([Entry Pages])>} Visits)
values are not getting changed on the selection of activity Type
Its not working
Try this:
=Sum({1<[Entry Pages]=p([Entry Pages])}, [activity type] = p([activity type])>} Visits)
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
=sum({<[(v0) Program Name] =, [Entry Pages]={$(vEntry)}>} Visits)
Hi Teis the expression
=' sum({1<[Entry Pages]={=$(vEntry)}>} Visits) '
is already working but my requirement is different
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