Discussion board where members can learn more about Qlik Sense App Development and Usage.
With reference to above subject, I am trying below formula in expressions but getting "Error in Expression".
(Sum(if(Levels = 'Level*', (Gross),'NA'))) / (sum((if(Levels = 'Level*', total (Gross),'NA'))))
Please see the above and help me to identify where I am making mistake.
Thanks in advance.
I cracked it finally, when I used below formula to fetch quarter wise details.
For percentage, I have used below formula -
Sum(Gross)/Sum(TOTAL <[EncDate.autoCalendar.YearQuarter]> Gross)
Also I have loaded only specific AcCodes while loading data instead of all AcCodes so as to avoid NULL values.
Hope this is helpful to all.
Thanks and Regards,