topic Re: Add column with calculated values in QlikView

Add column with calculated values

Sun, 28 Feb 2016 07:59:37 GMT

Hi,

Need expert advice.

My data like this:

Set 1:

ITEM Value Month

1 50 Jan

1 20 Jan

1 30 Feb

1 25 Feb

1 80 Mar

1 70 Apr

Set2:

Month Item defect

Jan 20

Feb 5

Mar 35

Apr 10

Now i want to show information as follows:

Month Item-Total Value Item-defect %

Jan 70 20 20/70*100

Feb 55 5 5/55*100

Mar 80 35 35/80*100

Apr 70 10 10/70*100

Please suggest, what the best view to show data in above format...List box or Chart..

Regards

Sandeep

Re: Add column with calculated values

maxgro — Mon, 29 Feb 2016 20:54:36 GMT

load your data

Set1:

load * inline [

ITEM Value Month

1 50 Jan

1 20 Jan

1 30 Feb

1 25 Feb

1 80 Mar

1 70 Apr

] (delimiter is spaces);

Set2:

load * inline [

Month Item defect

Jan 20

Feb 5

Mar 35

Apr 10

] (delimiter is spaces);

build a straight table chart with one dimension and 3 expressions

Re: Add column with calculated values

Mon, 29 Feb 2016 21:42:17 GMT

Thanks ...it worked

Re: Add column with calculated values

Chanty4u — Tue, 01 Mar 2016 06:03:19 GMT

Hi,

If you got the solution please close the thread.

Re: Add column with calculated values

Tue, 01 Mar 2016 14:17:14 GMT

I marked is "Answered". What do you mean by "Close".

I am new to this community, so please let me know if something else need to be done to "Close" the thread.