Help with GetFieldSelections

[helen_pip]

Dear Qlikview expert

I have a variable called vUser and the expression for this variable is:

GetFieldSelections($Field)

I would like to create an expression which will be dynamic, so the user can see a % of Sales by $Field

I.e. Count(GetFieldSelections($Field)ID/ ID)

However I am unsure on the correct way of writing this expression

Any help or guidance would be great

Kind Regards

Helen

[sunny_talwar]

Would you be able to provide few rows of data with the expected output you are hoping to see?

[migueldelval]

Hi Helen,

I can´t underst why you use count to make a % of sales;

Could you try this expression

SUM({<Field = {"=$(=GetFieldSelections(Field))"}>} ID)/sum(Total ID)

Regards

Miguel del Valle

[tresesco]

Your overall intention is not very clear to me. However, one partial suggestion would be to try expression a bit differently like:

GetFieldSelections("$(=$Field)")