topic Re: Simple dashboard in QlikView

Simple dashboard

AH — Sun, 14 Dec 2014 19:22:25 GMT

Hi,

Can anyone help me with this? In the Data file TotalLineAmount has negative values which indicates the credits. Gross amount is the sum of all positive and negative values.

I would really appreciate your help.

Thanks,

Shan

Re: Simple dashboard

Sun, 14 Dec 2014 23:06:30 GMT

Hi Shan,

I am not fully clear as to what you are looking for...

If you want to drop the negative sign then you can use the fabs() function.

This will ensure that you are working with only positive numbers. For example:

fabs( 2.4 ) returns 2.4

fabs( -3.8 ) returns 3.8

If you want to keep the signs and net the numbers off by ItemID or CurrencyCode for example then you could use the Aggr() function. The below example would give you a single number per ItemID.

=Aggr( Sum(TotalLineAmount), ItemID)

Does this help?

Re: Simple dashboard

AH — Mon, 15 Dec 2014 06:57:16 GMT

Hi Portolad,

Thanks for your reply. What i actually want is to calculate the credit amount (negative LineAmount) for ItemID A,B,C and L. Gross & Net Quantity for ItemID A,B,C and L. Gross & Net Amount for ItemID A,B,C and L. Your reply contains for All ItemID not for specific items.

I am attaching the apps here. Could you please have a look at it and suggest me. Also could you have a look at the chart for the Credit and Net amount over time? !