Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna789
Creator II
Creator II

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
Anil_Babu_Samineni

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))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

7 Replies
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Could you please provide a screenshot for this ?

krishna789
Creator II
Creator II
Author

Capture.PNG

AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Any sample data ?

Anil_Babu_Samineni

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))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
krishna789
Creator II
Creator II
Author

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
Creator II
Creator II
Author

Hi @loveisfail

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

Thanking You

krishna

davyqliks
Specialist
Specialist

Hi Anil,

I have seen your solved resolution and have tried to apply to my similar situation but cannot remove the cross from the Map where there is a null value.

 

I also need to remove the cross from the point layer.

I am using the following show null values unticked.

=Aggr(if(count([Facility Standard])>0, City),[Facility Standard],City)

 

Please can you help in how to make this dimension not show the cross on the map

davyqliks_0-1663073750816.png

 

Thanks in advance for your assistance,

 

Daniel