Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
just remove the S.No dimension from the table. PFA
Are you trying this? PFA
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
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
Dear Amuthabharathi,
Thanks for your reply!!
I can't do anything in script. No access
Can you suggest any expressions.
Hi,
Remove S.No you can get the answer
just remove the S.No dimension from the table. PFA
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.
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).