topic Re: range between in set in QlikView

range between in set

mallireddy_qv6 — Fri, 15 Nov 2024 23:48:58 GMT

Hi all

I want below in set analysis

Count({<ids=[500,...,950]>}Sales)

Instead of describing all of my ids between 500 and 950...?

Chanty4u — Tue, 13 Oct 2020 14:46:19 GMT

hi,

can you try this.

Count({<ids = {'>=500<=950'}>}Sales)

best

chanty

mallireddy_qv6 — Tue, 13 Oct 2020 14:59:28 GMT

thank you. I want to exclude . below values

how to do?

product not equal to "A,B,C"

Chanty4u — Tue, 13 Oct 2020 15:05:59 GMT

you can try like this

Count({<ids = {'>=500<=950'},Product-={'A','B','C'}>}Sales)

mallireddy_qv6 — Tue, 13 Oct 2020 15:10:58 GMT

thank you. its working.

Chanty4u — Tue, 13 Oct 2020 15:19:55 GMT

cool can you close this thread as accept as solution.