I'm New to Qlikview and i need to have below calculation,
I want to get the different with out adding a new feild in load statement?
Is there a way to get it?
Please help me
Try using chart inter record functions, like above().
I assume you've created a chart with a month dimension, and an expression with something like sum(Quantity).
The diff column could then look like
=sum(Quantity) - above(sum(Quantity))
Thanks, This works nice for me. Another one thing.
If i need to show - values in red color how can i do it?
Thanks For your help
In expression tab, click the '+' sign and give text color or background color for your condition using if() or give simply RGB(124,123,123)
Hope it helps
i need to have Red colour for this,
so how to use if condition with that.
if (sum(Quantity) - above(sum(Quantity)) < 0) then how to get the red color
Try like this,
Expression tab -> click '+' sign -> text color or background color -> in expression
if (sum(Quantity) - above(sum(Quantity)) < 0, Red())
Why don't you use, the tabpage
presentation or visual styles.
See the screenshot below
Create a table
with as dimension the months
and as expresions:
- Quantity with formula sum(if(month = '02',products,0))
- Difference with formula sum(if(month = '02',products,0)) - sum(if(month = '01',products,0))
This solved my problem.
Retrieving data ...