Getcurrentselections() in dimension

[#1]

Hi all,

Can I use getcurrentselections() function in dimension?

I have used this function in measure and it works fine.

eg:

Count({<getcurrentselections() >}EmployeeID, to get the employee count

But If I want to get the list of employees in a table

{getcurrentselections()}Employee,

it doesn't work.

Any Ideas group?

Mike

[#2]

Hi Vineeth,

I couldn't open your file, its a qvw file. when I try to open it in Qlik sense, it does not load any chart, just a blank page.

I am enclosing the qvf and screen shot of what I am trying to achieve.

Thank you for taking out time for this, really appreciate it. !

[vinieme12]

Sorry I'm using a personal edition and can't open your file. but i'm posting the expressions i used for the 4 sample charts , I believe you would need the 3rd or 4th one....try each one out.

Top Left: No Restrictions Chart

     =Count({<Question={1}>}Question)

Top Right: Question Selection Restricted:

     =Count({<Question=,Question={2}>}Answer)

Bottom Left: Answer Selection Restricted

     =Count({<Answer=,Question={3}>}Answer)

Bottom Right: Question and Answer Selection Restricted

     =Count({<Answer=,Question=,Question={4}>}Answer)

[#4]

I used P(), and it is sort of working.

count({1<Employee=P({<GetCurrentSelections>}),Question={'Q2'}>}distinct(Employee))

Except not I have an additional little problem i.e. I want this function to work when I use Filter 1 and not to work if I use Filter 2.

Any ideas?

[#5]

I used P(), and it is sort of working.

count({1<Employee=P({<GetCurrentSelections>}),Question={'Q2'}>}distinct(Employee))

Except not I have an additional little problem i.e. I want this function to work when I use Filter 1 and not to work if I use Filter 2.

Any ideas?

[vinieme12]

Hi Mike,

P({<GetCurrentSelections>} won't be needed, it is Qlikview's natural behaviour to show associated data.

Where and why are you using this expression?

count({1<Employee=P({<GetCurrentSelections>}),Question={'Q2'}>}distinct(Employee))