Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator II
Creator II

Help with GetFieldSelections

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

3 Replies
sunny_talwar

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

migueldelval
Specialist
Specialist

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
MVP
MVP

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

GetFieldSelections("$(=$Field)")