Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

anuradhaa
Contributor II

Need easy way for calculations

Hi all,

I'm New to Qlikview and i need to have below calculation,


quntitydifference



Jan15
feb205
march18-2
april4022

Like Thant.

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

Thanks

1 Solution

Accepted Solutions
MVP
MVP

Re: Need easy way for calculations

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))

8 Replies
MVP
MVP

Re: Need easy way for calculations

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))

alwinsch
Contributor

Re: Need easy way for calculations

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.

Regards,

A.

anuradhaa
Contributor II

Re: Need easy way for calculations

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

Re: Need easy way for calculations

Hi

     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

anuradhaa
Contributor II

Re: Need easy way for calculations

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

Re: Need easy way for calculations

Hi

     Try like this,

Expression tab -> click '+' sign -> text color or background color -> in expression

     =

if (sum(Quantity) - above(sum(Quantity)) < 0, Red())

Hope it helps

anuradhaa
Contributor II

Re: Need easy way for calculations

Great, Thanks

alwinsch
Contributor

Re: Need easy way for calculations

Hi,

Why don't you use, the tabpage

presentation or visual styles.

See the screenshot below

Visual_Style.png