Dimension Expression excluding two selections

[qliklizzy]

Hi

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

[sasiparupudi1]

Please have a look at

Preparing examples for Upload - Reduction and Data Scrambling

[qliklizzy]

thanks very much! thats really good.

...so how do I share?

[sasiparupudi1]

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

see if this helps

Re: Attach pdf

[qliklizzy]

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

[qliklizzy]

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!

[sasiparupudi1]

Hi

The expression

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

?

[qliklizzy]

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

[qliklizzy]

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)