topic Re: How to filter points within a same layer with Articque ? in QlikView

How to filter points within a same layer with Articque ?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have imported a set of points (POINTS) with the Articque module. I only want to represent a subset of these points (TYPE 1). How could I achieve this?

I have tried with the following syntax: =({TYPE = {'1'}}POINTS)

Thanks for any help!

Re: How to filter points within a same layer with Articque ?

Anil_Babu_Samineni — Sun, 24 Sep 2017 05:30:50 GMT

You can use P() for possible or E() for Exclude

=Sum({<TYPE = P({<TYPE = {1}>} TYPE)>} Sales)

=Sum({<TYPE = P({1<TYPE = {1}>} TYPE)>} Sales)

Re: How to filter points within a same layer with Articque ?

Kushal_Chawda — Sun, 24 Sep 2017 09:39:01 GMT

try

sum({<Type={"1"}>}POINTS)