Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a List Box with a unique key as Field and the accompanying namefield as Expression. When I select one value (one unique key) the expression values of all the other unique keys (names) are not displayed anymore (grey and displaying the minus sign). Logical and ok. But, is there a way to keep the expression values displayed in grey instead of the minus sign? Just as the unique keys are also still shown in grey?
check the what's new in QV 10 document, notice how listbox expressions don't dissapear after a selection is done because set analysis is being used.
If it's the field "Year" selection expressions do sum({<Year=>} Sales) so QlikView will not consider the year selection and will show all expressions.
With your reply and additional advice locally what worked for me is: =ONLY( {1} Projects.NAME)
Sum returned zeros since I'm using namefields (characters) as expression. Regards, Sander.