Hi Guys , I have a dataset like below , I want create a map whose measure axis query is showing those Customers whose SellType is Promot on Map, How to do this in qliksense??

[#1]

Hi Guys , I have a dataset like below , I want create a map whose measure axis query is showing those Customers whose SellType is Promot on Map, How to do this in qliksense??  

Customer	SellType	Lat	Long
XG970201	NORMAL	25.2667	56.3333
XE057701	NORMAL	25.8	55.96667
XE711301	PROMOT	25.8	55.96667
XE355501	PROMOT	25.8	55.96667
XF970201	PROMOT	25.98333	55.93333
XE530601	PROMOT	25.8	55.96667
XE653901	PROMOT	25.8	55.96667
XE653901	PROMOT	25.8	55.96667
XH700501	PROMOT	25.2667	56.3333
XE530601	PROMOT	25.8	55.96667
XE650301	PROMOT	25.8	55.96667
XG194401	NORMAL	25.2667	56.3333
XE530601	NORMAL	25.8	55.96667
XE530601	NORMAL	25.8	55.96667

Thanks,

Bibhuti

[Anonymous]

may be like?

=only({<SellType={'PROMOT'>} Lat)

=only({<SellType={'PROMOT'>} Long)

[#3]

Thanks Mr Balraraj,

Where I will write this expression ??

It's not taking inside GeoMakePoint()

[Anonymous]

Okay, then I would suggest restrict your dataset while loadind QVD, like:

Load

Customers,

SellType,

Lat,

Long

from QvdName where SellType='PROMOT';

You can use GeoMakePoint() now..

[#5]

We cannnot write it as Query inside Dimension axis while creating Map??