Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

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

CustomerSellTypeLatLong
XG970201NORMAL25.266756.3333
XE057701NORMAL25.855.96667
XE711301PROMOT25.855.96667
XE355501PROMOT25.855.96667
XF970201PROMOT25.9833355.93333
XE530601PROMOT25.855.96667
XE653901PROMOT25.855.96667
XE653901PROMOT25.855.96667
XH700501PROMOT25.266756.3333
XE530601PROMOT25.855.96667
XE650301PROMOT25.855.96667
XG194401NORMAL25.266756.3333
XE530601NORMAL25.855.96667
XE530601NORMAL25.855.96667

Thanks,

Bibhuti

4 Replies
balrajahlawat
Esteemed Contributor

Re: 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??

may be like?

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

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

Not applicable

Re: 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??

Thanks Mr Balraraj,

Where I will write this expression ??

It's not taking inside GeoMakePoint()

balrajahlawat
Esteemed Contributor

Re: 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??

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

Not applicable

Re: 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??

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