Hi Friends I have a dataset like below.. I want to retrieve Customers with SellType is PROMOT. Please suggest me..

[#1]

Customer	SellType
XG970201	NORMAL
XE057701	NORMAL
XE711301	PROMOT
XE355501	PROMOT
XF970201	PROMOT
XE530601	PROMOT
XE653901	PROMOT
XE653901	PROMOT
XH700501	PROMOT
XE530601	PROMOT
XE650301	PROMOT
XG194401	PROMOT
XE530601	PROMOT
XE530601	NORMAL
XE530601	NORMAL

Hi Friends

I have a dataset like below.. I want to retrieve Customers whose SellType is PROMOT what will be the query. Please suggest me..

Thanks,

Bibhuti

[swuehl]

In your script:

LOAD

Customer,

SellType

FROM YourTable

WHERE SellType = 'PROMOT';

[sunny_talwar]

Within QlikView's script you want to do that??? If yes then may be this:

TableName:

LOAD Customer,

          SellType

FROM Source

Where SellType = 'PROMOT';

[#4]

Thanks All for your great response,

Can it is possible to directly write the query at the time of visualization??

I want to write query on Dimension axis to make it visualize... Is it possible??

Thanks

[sunny_talwar · Accepted solution]

Sure, add this to your set analysis within the expression:

{<SellType = {'PROMOT'}>}

This will restrict SellType to only PROMOT

[#6]

Thanks Mr Sunny,

I need this query.. Thanks again for your valuable response.

[#7]

Hi Mr Sunny,

I want retrieve Customers whose SellType is Promot.

What will be the Query ???

Thanks

[sunny_talwar]

We need to know what object you are working with? Did this -> {<SellType = {'PROMOT'}>} in your expression not work?

[#9]

Expression working but nor returning Customers.

[sunny_talwar]

Which object are you using? Text Box object? Straight table?

If you are looking for a concatenated list of customer in a text box, then try this -> Concat(DISTINCT {<SellType = {'PROMOT'}>} Customers)