Create a chart from values in table

[#1]

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

[tresesco]

Are you trying this? PFA

[#3]

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

[#4]

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

[#5]

Dear Amuthabharathi,

Thanks for your reply!!

I can't do anything in script. No access

Can you suggest any expressions.

[#6]

Hi,

Remove  S.No you can get the answer

[tresesco · Accepted solution]

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

[#8]

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.

[tresesco]

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).