topic Re: Dimension Expression excluding two selections in QlikView

Dimension Expression excluding two selections

qliklizzy — Thu, 17 Sep 2015 11:05:05 GMT

i have an expression in dimension which allows my table to be unchanged when making a selection on that specific item.

(Aggr(Rank(count({<FlagType={'Session Record'}>}{$< BookedConsultantName = >}EpisodeID),4), PrimaryProcedureName)<=6,PrimaryProcedureName)

but i now need to add another unchanged selection:

so i tried this but failed...

(Aggr(Rank(count({<FlagType={'Session Record'}>}{$< BookedConsultantName = >} {<FlagType={'Operation Record'}>}{$< ConsultantName = >} EpisodeID),4), PrimaryProcedureName)<=6,PrimaryProcedureName)

i thought i could just add another simply to the count? any ideas?

Thanks

Re: Dimension Expression excluding two selections

sasiparupudi1 — Thu, 17 Sep 2015 11:12:56 GMT

Try

(Aggr(Rank(count({<FlagType={'Session Record'},BookedConsultantName=,FlagType={'Operation Record'},ConsultantName=>} EpisodeID),4), PrimaryProcedureName)<=6,PrimaryProcedureName)

Re: Dimension Expression excluding two selections

qliklizzy — Thu, 17 Sep 2015 11:16:11 GMT

thanks have just tried..

i get error in expression ; with the error showing at the comma after 6, prcoedure name greyed out?

Aggr(Rank(count({<FlagType={'Session Record'},BookedConsultantName=,

FlagType={'Operation Record'},ConsultantName=>} EpisodeID),4), PrimaryProcedureName)<=6,PrimaryProcedureName)

Re: Dimension Expression excluding two selections

sasiparupudi1 — Thu, 17 Sep 2015 11:18:34 GMT

are you using this in a if condition? would you please share your complete expression?

Re: Dimension Expression excluding two selections

qliklizzy — Thu, 17 Sep 2015 11:21:43 GMT

sorry my bad; yes there is an IF(

Thank you - works perfect!

Re: Dimension Expression excluding two selections

qliklizzy — Thu, 17 Sep 2015 11:52:49 GMT

sorry, the consutlant works but the booked consultant doesnt.

its still selecting the data when you select on booked consutlant?

The info that its counting is in the operation records not the session records so may be why it works for consultantName, but having said that it works on one exclusions for booked consultant - so its struggling to do them both

thanks

Re: Dimension Expression excluding two selections

sasiparupudi1 — Thu, 17 Sep 2015 12:00:22 GMT

try the following, it will show error because of the - sign

if (Aggr(Rank(count({<FlagType={'Session Record','Operation Record'},BookedConsultantName-={'*'},ConsultantName=>} EpisodeID),4), PrimaryProcedureName)<=6,PrimaryProcedureName)

hth

Sasi

Re: Dimension Expression excluding two selections

qliklizzy — Thu, 17 Sep 2015 12:04:45 GMT

thanks once again!

expression is ok, but still fails to show data when bookedconsultabt selected.

i do have expressions on the data also; to show the count by those procedures whether this impacts why data does not come through - becuase i used the same kind of expression as i did for the dimension:

count({<FlagType={'Session Record'}>}{$< BookedConsultantName = >} {<FlagType={'Operation Record'}>}{$< ConsultantName = >} EpisodeID)

Re: Dimension Expression excluding two selections

sasiparupudi1 — Thu, 17 Sep 2015 12:25:55 GMT

Would you mind sharing a sample?

Re: Dimension Expression excluding two selections

qliklizzy — Thu, 17 Sep 2015 12:33:38 GMT

how would i do that ?

its hospital theatre data you see; and wouldnt be able to share patient detal

Re: Dimension Expression excluding two selections

sasiparupudi1 — Thu, 17 Sep 2015 12:44:22 GMT

Please have a look at

Preparing examples for Upload - Reduction and Data Scrambling

Re: Dimension Expression excluding two selections

qliklizzy — Thu, 17 Sep 2015 13:24:08 GMT

thanks very much! thats really good.

...so how do I share?

Re: Dimension Expression excluding two selections

sasiparupudi1 — Thu, 17 Sep 2015 13:47:10 GMT

Use the advanced editor option on the top right hand cornor to attach a file

see if this helps

Re: Attach pdf

Re: Dimension Expression excluding two selections

qliklizzy — Thu, 17 Sep 2015 13:51:14 GMT

thanks but
doesnt look like the advanced editor is available to me

Re: Dimension Expression excluding two selections

qliklizzy — Thu, 17 Sep 2015 14:22:05 GMT

hi i can - it is becuase i was viewing from email when replying!

this is the first app i have been working on which will expain my knowledge.

the issue is on the consultant tab i have table for: procedures ALL consultants which isnt showing becuase of the dimension, i think.

the reason why I need to exclude selections made is becuase procedure data is stored as operation record using consutlantname; and to view session times i need to view that by booked consutlant under the session record

its so confusing; if only consutlants worked under their own sessions all of the time!

thanks for this!

Re: Dimension Expression excluding two selections

sasiparupudi1 — Fri, 18 Sep 2015 09:02:53 GMT

The expression

aggr(count({<FlagType={'Session Record','Operation Record'},BookedConsultantName=,ConsultantName=>} EpisodeID) ,PrimaryProcedureName) returns 1

Re: Dimension Expression excluding two selections

qliklizzy — Fri, 18 Sep 2015 09:20:54 GMT

I have just put that in to your version it works until i select on booked consutlant ?

the scambler scambled the booked consultant and consultantname to be different

i have been using

booked consutlant = IDGQ,PPIDD H which equals consutlant name to be DVWP,ZIWCX E when trying to show this consutlants times and op times

thanks

Re: Dimension Expression excluding two selections

qliklizzy — Fri, 18 Sep 2015 13:07:34 GMT

i have played around with all your expressions and i have got it to work!!!! but i have come into more trouble now; i cant get the unadjusted from selections to compare with the selected selections. feel like giving up! might have a go at doing it in just the expressions and not dimensions see if that will work

thanks for your help

-- at least the below is possible and can be used in some future repots maybe

if(aggr(rank(count({<FlagType={'Session Record','Operation record'},BookedConsultantName=,ConsultantName=>} EpisodeID),4),PrimaryProcedureName)<=6,PrimaryProcedureName)