topic Re: code in a PivotTable in QlikView

code in a PivotTable

Tue, 27 Mar 2012 08:56:15 GMT

Hello All,

I am creating a PivotTable. This table shows unique numbers where test numbers included. As an example:

Column1

(unique numbers) Column2 (testnumbers)

11254 38546

11254 58745

11254 98562

11589 38596

11589 65845

11589 25698

11589 25845

11589 54856

When I make a PivotTable from here (see annex) do I should actually have a formula that represents whether there is a testnumber (38546 of 38596) in it. If attachment is an example of what I mean. So if there is a testnumber (38546 of 38596) in the unique numbers that must give Yes or No.

thank you very much for the reply.

with kind regards,

Hans

Re: code in a PivotTable

jvitantonio — Tue, 27 Mar 2012 09:34:32 GMT

Hi, check this application. I hope it helps.

code in a PivotTable

Tue, 27 Mar 2012 09:41:37 GMT

Hoi,

Heel erg bedankt , hier kan ik zeker wat mee.

p.s. is dit een nederlands forum of is het beter dat ik alles er in het Engels neer zet?

code in a PivotTable

jvitantonio — Tue, 27 Mar 2012 09:45:51 GMT

Sorry, I don't speak your language. You can post in any language but you will definetly get more answers if you post in English that is the common language!

code in a PivotTable

Tue, 27 Mar 2012 09:58:36 GMT

Oke Thanks