topic Re: Calculated fields as filters/selections in QlikView

Calculated fields as filters/selections

josephinetedesc — Sat, 14 Feb 2015 11:11:00 GMT

If I have two fields regarding orders - one called Plastic Orders, one called vinyl Orders. I do want to keep them separate most of the time, however when I want to select all orders, how do I do this with?

so the data comes in like this:

PO VO

2 10

3 12

6 15

but I want to be able to click on a button??? that would enable someone to select Orders and total orders or PO and VO woulld show.

Is a button the only way to do this?

Thank you

Re: Calculated fields as filters/selections

alexandros17 — Sat, 14 Feb 2015 11:23:32 GMT

Please Jo add more details, where do you see orders separately (which object ) and where do you need to see all the orders?

Add more info.

Monday morning I''answer

Re: Calculated fields as filters/selections

sunny_talwar — Sat, 14 Feb 2015 11:27:22 GMT

From what I understand you want to show Sum(PO) and Sum(VO) alternatively. This could be done in a bunch of ways:

1) you can have a single expression which says =If(vOrders = 0, Sum(PO), Sum(VO)) and your button will have a action of setting the variable vOrders with a value =If(vOrders = 0, 1, 0)

2) Alternatively, you can create two expressions, Sum(PO) and Sum (VO) and make them conditional by saying if vOrders = 0 for Sum (PO) and vOrders = 1 for Sum(VO)...

HTH

Best,

Re: Calculated fields as filters/selections

josephinetedesc — Sat, 14 Feb 2015 11:44:54 GMT

Re: Calculated fields as filters/selections

josephinetedesc — Sat, 14 Feb 2015 11:46:22 GMT

Thank you I will try the suggestion now.

Re: Calculated fields as filters/selections

sunny_talwar — Sat, 14 Feb 2015 13:12:01 GMT

I am not sure if this is what you are looking to do, but PFA a qvw file and see if this is what you want.

Best,

Re: Calculated fields as filters/selections

josephinetedesc — Sun, 15 Feb 2015 23:10:37 GMT

Thank you Sunindia - and here is the solution I worked out using a text object.