topic Re: How to take values from one column to another in QlikView

How to take values from one column to another

ivanaksen — Fri, 17 Aug 2018 08:53:48 GMT

Hello dear all,

I have a tough question, which trying to resolve third day:

So, I have massive of data, but it`s necessary to make some changes

It`s necessary to have: If there are values with "-" at the beginning, they should have the same Aging as the next value without "-" at the beginning. So I have bellow formulas in visualisation:

Aging is taking from script;

Current is Sum({<[Aging] = {"<89"}>} [Amount.Loc]);

Aged over is Sum({<[Aging] = {">89<179"}>} [Amount.Loc]);

Total is sum([Amount.Loc])

So the main aim is to have sum of money with "-" at the same column as the next positive sum.

Thanks in advance

Re: How to take values from one column to another

PrashantSangle — Fri, 17 Aug 2018 08:57:50 GMT

Hi,

what is required output???

Regards

Re: How to take values from one column to another

ivanaksen — Fri, 17 Aug 2018 09:00:00 GMT

So in above example, all data should be in Aged Over 90. And should look equal as Total.

Aging should be '155' as last Positive value

Re: How to take values from one column to another

PrashantSangle — Fri, 17 Aug 2018 09:05:02 GMT

sorry i don't get your logic..

Regards,

Re: How to take values from one column to another

ivanaksen — Fri, 17 Aug 2018 09:13:11 GMT

Sorry for not quite understandable explanation.

So, we have sums of money for 1 vendor. And if aging is more than 90 days, these sums go to column Aged over 90.

If less, they are in column Current. But there are 2 types of these sums, which are begins with "-" and without it.

The aim to have sums with "-" with same aging, which has next sum without "-".

So if again it`s about above example, we have five sums of money with minuses at the beginning, and last sum without it. So all five sums, should have aging 155 as the last raw.

Re: How to take values from one column to another

BalaBhaskar_Qlik — Fri, 17 Aug 2018 11:00:42 GMT

Do you want to make -ve values in current column, as Positive in the next column, right?

Re: How to take values from one column to another

ivanaksen — Fri, 17 Aug 2018 11:03:00 GMT

Yes, -*value* should have the same column as the next positive value for the vendor

Re: How to take values from one column to another

d_ankusha — Fri, 17 Aug 2018 11:15:12 GMT

Use Fabs() function on the same expression

Re: How to take values from one column to another

manoj217 — Fri, 17 Aug 2018 12:30:32 GMT

use column function

Re: How to take values from one column to another

BalaBhaskar_Qlik — Fri, 17 Aug 2018 12:47:31 GMT

Change the number format:

You can set your expression as integer (for example) :

#.##0;#.##0

the second format is for negative values.

You could use

#.##0;(#.##0) to include () on negative values instead of '-'

Re: How to take values from one column to another

ivanaksen — Fri, 17 Aug 2018 12:50:03 GMT

Dear All,

Thank a lot for your replies, the requester told, that he doesn't need this thing anymore

Have a nice day

Re: How to take values from one column to another

BalaBhaskar_Qlik — Fri, 17 Aug 2018 12:56:01 GMT

That's good to hear, Finally You convinced the Client ..