topic Re: Help with GetFieldSelections in QlikView

Help with GetFieldSelections

helen_pip — Fri, 11 Nov 2016 11:50:43 GMT

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 — Fri, 11 Nov 2016 12:08:08 GMT

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

migueldelval — Fri, 11 Nov 2016 12:10:44 GMT

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

tresB — Fri, 11 Nov 2016 12:38:07 GMT

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

GetFieldSelections("$(=$Field)")