topic month and year selection in QlikView

month and year selection

Wed, 30 May 2012 11:48:07 GMT

Dear qlikview community.

I'm a student who is starting to learn to work with qlikview, but sadly I've come upon a challenge. I'm trying to make a double selection out of a set of data but I can't seem to figure out how to do this. I've tried:

Sum ({$<verkoopmaand={$(='apr')}>} {$<verkoopjaar={$(='2011')}>} verkoopaantal)

But when I do that qlikview simply doesn't register the first conditonal.

Can anyone help?

With kind regards,

Allard Swart

month and year selection

Sokkorn — Wed, 30 May 2012 11:58:49 GMT

Hi Allard,

Try this Sum ({$<verkoopmaand = {'apr'}, verkoopjaar = {'2011'}>} verkoopaantal)

Do let me know.

Regards,

Sokkorn

month and year selection

Wed, 30 May 2012 12:00:46 GMT

That works like a charm.

Thanks a lot!