Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

krishna789
Contributor

How to remove cross marks on map in qliksense?

Hi ,

my issue is  i want show loads >30 and month(today())  .point layer=destinations

measure=if(month(today()),if(count(loads)>30,count(loads),''))

the   problem  is  with destinations  . The destination  having loads greater than 30 is coming in cricle but reminig destination coming in cross mark .the destination are not  filtering according to measure how to handle  this issue

thanksyou

krishna

1 Solution

Accepted Solutions

Re: How to remove cross marks on map in qliksense?

Because, The cross marks are getting values as Null values? Can u define like below

=Sum(Aggr(if(month(today()),if(count(loads)>30,count(loads),'')), YourDim))

6 Replies
ashutoshbhumkar
New Contributor II

Re: How to remove cross marks on map in qliksense?

Could you please provide a screenshot for this ?

krishna789
Contributor

Re: How to remove cross marks on map in qliksense?

Capture.PNG

ashutoshbhumkar
New Contributor II

Re: How to remove cross marks on map in qliksense?

Any sample data ?

Re: How to remove cross marks on map in qliksense?

Because, The cross marks are getting values as Null values? Can u define like below

=Sum(Aggr(if(month(today()),if(count(loads)>30,count(loads),'')), YourDim))

krishna789
Contributor

Re: How to remove cross marks on map in qliksense?

Hi Anil Babu,

Thank u for your reply ,But Now it is coming Small circle.

Untitled123.png

It should show only  loads>30 .

i used :Sum(Aggr(if(month(today()),if(count(loads)>30,count(loads),'')), destination)).

pls correct me if i am worng.@Anil Babu

Thanking You

Krishna

krishna789
Contributor

Re: How to remove cross marks on map in qliksense?

Hi @loveisfail

Thanks it worked .I did not uncheck the " Include Zero Value".

Thanking You

krishna

Community Browser