Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Woohoo! Qlik Community has won “Best in Class Community” in the 2024
Khoros Kudos awards!
Hello QV Gang,
Looking for some assistance in getting a desired result.
I still want to show the xyz corp, but don't want to include it in the % expression.
as illustrated below it shows a 5% total but I want it to show 9.2%... since there are no returns for xyz corp I don't want those sales values used in the calculation which would bring it to a 9.2%.
The terminology I've always used is calling this an apples to apples comparison.
I'd rather not filter out the "bad apples" but show them in the report/chart as well...so those 'holes' can be fixed.
Also attached is this sample .qvw
thx
Brooks
1 Solution
Accepted Solutions
I am considering that calculation should be dynamic, so let's say if you have return 0 for abc corp then you should exclude abc corp and vice versa. In this case above expression will not work as company name is hard coded. You can use below expression in that case
=Sum({$<transtype={'returns'}, company={"=Sum({$<transtype={'returns'}>}dlr)>0"}>}dlr)/
Sum({$<transtype={'sales'}, company={"=Sum({$<transtype={'returns'}>}dlr)>0"}>}dlr)
Sum({$<
transtype={'returns'}
,company-={'xyz corp'}
>}
dlr)
/
Sum({$<
transtype={'sales'}
,company-={'xyz corp'}
>}
dlr)
If you use above expression you will get this:
I am considering that calculation should be dynamic, so let's say if you have return 0 for abc corp then you should exclude abc corp and vice versa. In this case above expression will not work as company name is hard coded. You can use below expression in that case
=Sum({$<transtype={'returns'}, company={"=Sum({$<transtype={'returns'}>}dlr)>0"}>}dlr)/
Sum({$<transtype={'sales'}, company={"=Sum({$<transtype={'returns'}>}dlr)>0"}>}dlr)
