Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
I need your help.
In a table, I compare Price 2022 vs. 2021. The prices have been calculated as scenario in differently crazy formulas with max and mode function.
In the rows everything works. But I would like to have another value in the TOTAL Value.
Qliks output is the average of both percentage values = 13,125%.
I would like to have the price increase in relation to the volume. In other words, the price increase for the supplier. is this possible?
please post some sample data, and expected output
Unfortunately, I cannot export Qlik data as CV .file
I have mentioend an excel example above.
Price increase in a row is (Preis2022/Preis2021)-1. The output in the row is OK.
Bute the average for TOTAL value should be 6,267% not 13,125%. (Price development for both material in relation to quantity.
Never export and post your actual data
but , you can create dummy data with dummy values that represents your dataset
in my post are dummy data
a small mistake in my excel file has been eliminated.