Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
i am attaching an excel sheet and qvw and required help on calcuating on these in qlikview
please require your help
Something like this?
Expression:
If(GARAGE = Above(GARAGE), (([YTD 2014 VS 2015]/Above([YTD 2014 VS 2015]) * 100) - 100), 0)
Where [YTD 2014 VS 2015] is the column label for the second last column (it is turned blue when you check the expression)
any suggestions?
With inter-record functions like above/below/before/after could you access the rows/columns around a cell and to reference them per column() or their label might be also helpful. But in your case with several different metrics you will need for each column an own expression with set analysis conditions and by calculation like previous year against the current year you need both expressions in one, like:
sum({< Year = {2014}>} value) / sum({< Year = {2015}>} value)
- Marcus
Thanks Marcus
if possible could you please share me the app?
Currently I have only the PE available and have only looked at the excel-file.
- Marcus
ok thanks never mind Marcus
but its not giving me the results in qv
Yes, it couldn't work if you used the expression directly - they was derived generic. You need to adjust it to your datamodel and the real field-names - it seems that you used a combined field from years and a category which results in FW 2014, TV 2015 .... and I have no idea how your datamodel looks like.
- Marcus
Thanks again Marcus
i 've given the original fields but didnt turn up as per the requirement:(
any help?
Something like this?
Expression:
If(GARAGE = Above(GARAGE), (([YTD 2014 VS 2015]/Above([YTD 2014 VS 2015]) * 100) - 100), 0)
Where [YTD 2014 VS 2015] is the column label for the second last column (it is turned blue when you check the expression)