Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Would you be able to provide few rows of data with the expected output you are hoping to see?
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
Your overall intention is not very clear to me. However, one partial suggestion would be to try expression a bit differently like:
GetFieldSelections("$(=$Field)")