topic Re: How to read columns in Table? in QlikView

How to read columns in Table?

Thu, 28 Aug 2014 05:31:28 GMT

Hi,

I got a table as below where I got a "ORDER" and "RECEIVED" column. I want to calculate "RECEIVED" column received plus "ORDER" columns rows "RECEIVED = 0". please find the table and columns to be calculated below. Thanks! in advance.

DATE	ORDER	RECEIVED
Apr-12	2,437,701	2,433,701
May-12	3,462,796	3,4502796
Jun-12	3,293,204	3,200,204
Jul-12	4,537,285	4,537,285
Aug-12	3,347,838	0
Sep-12	3,302,835	0
Oct-12	3,035,546	0
Nov-12	2,995,542	0
Dec-12	3,170,730	3,170,730
Jan-13	3,081,588	3,081,588

Re: How to read columns in Table?

avinashelite — Thu, 28 Aug 2014 05:42:37 GMT

Hi Mafaz,

Can you please elaborate your requirement and please post your app.

Re: How to read columns in Table?

its_anandrjs — Thu, 28 Aug 2014 05:45:38 GMT

Can you elaborate more please not understood clearly.

Re: How to read columns in Table?

vardhancse — Thu, 28 Aug 2014 05:45:39 GMT

what exactly you are trying to achieve.

Receive+orders where received=0

Re: How to read columns in Table?

PrashantSangle — Thu, 28 Aug 2014 05:47:50 GMT

Hi,

What is your actual requirement?

As per my understanding, You want

Order + Received when Received=0

If this is your requirement then try like

If(Received=0,Order,Received)

If this is not requirement then plz elaboarate with your required Output.

Regards,

Re: How to read columns in Table?

settu_periasamy — Thu, 28 Aug 2014 05:59:43 GMT

find the below attachment

Re: How to read columns in Table?

Thu, 28 Aug 2014 06:00:32 GMT

Jaufer

can you be more specific in your question

Re: How to read columns in Table?

Thu, 28 Aug 2014 06:04:43 GMT

guys what I want is... I have ordered some goods. its in the "ORDER" column

and within those orders I have received some goods. those are in "RECEIVED" column

what I exactly want is I want to see the YTD of my budget. which means what I have received + what I'am about to receive.

PLEASE FIND THE COLOURED VALUES IN THE TABLE. I WANT TO "SUM" THOSE VALUES.....

Re: How to read columns in Table?

ashfaq_haseeb — Thu, 28 Aug 2014 06:14:30 GMT

For Received

=sum(RECEIVED)

For Ordered

=if(RECEIVED=0,sum(ORDER),0)

For clubbing all together try below

=if(RECEIVED=0,sum(ORDER),sum(RECEIVED))

Regards

ASHFAQ

Re: How to read columns in Table?

PrashantSangle — Thu, 28 Aug 2014 06:18:16 GMT

Hi,

Simply try with,

if(Received=0,Sum(Ordered),Sum(Received))

Regards

Re: How to read columns in Table?

Thu, 28 Aug 2014 06:22:20 GMT

Hi ,

Try like this,

=if(RECEIVED = 0,ORDER,0)+sum(RECEIVED)

Thanks

Saurabh

Re: How to read columns in Table?

Thu, 28 Aug 2014 06:26:19 GMT

Hi,

pls find the sample attached qvw which may be the solution for your req as per my understandigs.

Re: How to read columns in Table?

CELAMBARASAN — Thu, 28 Aug 2014 06:31:19 GMT

Hi,

Try this

=Sum(RECEIVED) + Sum({<RECEIVED={0}>}ORDER)

Re: How to read columns in Table?

Thu, 28 Aug 2014 06:45:37 GMT

Hi all,

Please find the attachment below. I guess YTD and Last Year YTD are wrong.

according to the budget I want see YTD. Please help me...

Re: How to read columns in Table?

MarcoWedel — Thu, 28 Aug 2014 07:31:14 GMT

=If(Received,Received, Order)

Re: Re: How to read columns in Table?

MarcoWedel — Thu, 28 Aug 2014 07:40:42 GMT

Hi,

one solution:

hope this helps

regards

Marco

Re: Re: Re: How to read columns in Table?

MarcoWedel — Thu, 28 Aug 2014 07:45:09 GMT

hope this helps

regards

Marco