Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sure, add this to your set analysis within the expression:
{<SellType = {'PROMOT'}>}
This will restrict SellType to only PROMOT
In your script:
LOAD
Customer,
SellType
FROM YourTable
WHERE SellType = 'PROMOT';
Within QlikView's script you want to do that??? If yes then may be this:
TableName:
LOAD Customer,
SellType
FROM Source
Where SellType = 'PROMOT';
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
Sure, add this to your set analysis within the expression:
{<SellType = {'PROMOT'}>}
This will restrict SellType to only PROMOT
Thanks Mr Sunny,
I need this query.. Thanks again for your valuable response.
Hi Mr Sunny,
I want retrieve Customers whose SellType is Promot.
What will be the Query ???
Thanks
We need to know what object you are working with? Did this -> {<SellType = {'PROMOT'}>} in your expression not work?
Expression working but nor returning Customers.
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)