topic filter only positive values in QlikView

filter only positive values

Mon, 18 Jul 2011 10:35:03 GMT

Dear all,

i have the pivot table like

Type subtype Company XXX YYY ZZZ AAA BBB

A --- 100 120 230 322 223

B ---- -20 22 31 13 32

C --- -100 21 23 434 34

i need to show the table only those type C is positive. also i need to show the A and B as well. in this ex i have to exclude the XXX Comp.

I have sub type also. but i have to consider only type =c.

for type A is having the subtype a1,a2,a3. similayly for B also. but c is not having any subtypes.

Could any one help me ...

rahulgupta — Mon, 18 Jul 2011 11:04:29 GMT

Hey Hi,

Kindly check out the Application attached and revert back for further issues(if any).

Regards,

Rahul Gupta

alwinsch — Fri, 18 Jan 2013 12:28:11 GMT

Hi Rahul,

I saw your example and it helps with my problem.

But how did you do this?

can you convert the '-' for column XXX to value 0?

Thanks.

Alwin