Discussion Board for collaboration on QlikView Layout & Visualizations.
I was stuck at small expression. I need to show sum(L2AMID_VALUE_USD) in the basis of L2AMID field. I have used in AGGR in expression. But it is not working.
Please help to find solution. Please find the attached QVW.
L2AMID ===> Account ids
L2AMID_VALUE_USD ====> Measure in USD$
Go to Solution.
Is that you want
Thanks for your reply. It is showing wrong totals. It is not working properly
Hi - I could see two dimesions are already in use. While solution given by max dreamer should work, could you please let us know what is the expected result?
sorry..It is working..Thanks Max