topic Create a chart from values in table in QlikView

Create a chart from values in table

Tue, 01 Oct 2013 04:46:51 GMT

Dear Experts,

I am very new to Qlikview. I Strucked in the below Scenario. Could anyone help me to overcome the below scenario.

All i need is want to exclude the line contains Zero.

Example:

Raw Data:

S.NO Product Category Sales Sales(Last Year)

1 Pen A 50 25

2 Pencil A 52 20

3 Paper A 0 10

4 Marker B 50 40

Chart 1:

S.NO Product Category Sales Sales(Last Year)

1 Pen A 50 25

2 Pencil A 52 20

3 Marker B 50 40

I had an Expression to exclude Zero as above in chart 1,

It's working fine when i view the chart using "Product"

But when i want to view "Category wise", The sales(Last Year) for "Category A" is showing as 55.

Chart 2:

S.NO Category Sales Sales(Last Year)

1 A 102 55

2 B 50 40

I think of pulling data from Chart 1 to Chart 2. Is it possible or is there any other way to overcome this issue?

Please let me know, if you feel trouble in understanding my question.

Warm Regards,

Pradeep

Re: Create a chart from values in table

tresB — Tue, 01 Oct 2013 05:06:07 GMT

Are you trying this? PFA

Re: Create a chart from values in table

Tue, 01 Oct 2013 05:09:51 GMT

Hi,

Use the following way in your script

Check:

LOAD * Inline [

S.NO,Product,Category,Sales,Sales(Last Year)

1,Pen,A,50,25

2,Pencil,A,52,20

3,Paper,A,0,10

4,Marker,B,50,40

];

NoConcatenate

Test:

LOAD

S.NO

,Product

,Category

,Sales

,[Sales(Last Year)];

LOAD

S.NO

,Product

,Category

,Sales

,[Sales(Last Year)]

Resident Check

where Sales>0;

PFA,

Hope it helps you

Re: Create a chart from values in table

Tue, 01 Oct 2013 05:14:33 GMT

Dear Tressco,

Thanks a lot for your answer.

But I want the chart 2 to be like below.

S.No

A 102 45

B 52 40

Re: Create a chart from values in table

Tue, 01 Oct 2013 05:16:04 GMT

Dear Amuthabharathi,

Thanks for your reply!!

I can't do anything in script. No access

Can you suggest any expressions.

Re: Create a chart from values in table

Tue, 01 Oct 2013 05:16:54 GMT

Hi,

Remove S.No you can get the answer

Re: Re: Create a chart from values in table

tresB — Tue, 01 Oct 2013 05:17:25 GMT

just remove the S.No dimension from the table. PFA

Re: Create a chart from values in table

Tue, 01 Oct 2013 08:10:53 GMT

If i want to use conditions how can i do that.

Please find the expressions below. Which i have used . But it's result in error.

Sum(If(VBRK.$(vCurrency)LISTPRICE>0 and ({$<$(vComparison_Selection)>}VBRK.$(vCurrency)LISTPRICE>0,[VBRK.$(vCurrency)KZWI2])))

Can you please help.

Re: Create a chart from values in table

tresB — Tue, 01 Oct 2013 08:17:23 GMT

Hi Pradeep,

Please explain in words what you intend to achieve (conditional part) and create a new thread for it to get more attention of more people(people willing to help normally do not pay attention to answered post).