How to apply condition for qvd file with multiple values for one field?

[jagannalla]

Hi,

I've a qvd file with filds 4 with data as shown below:

- I had a list box with B field as shown below:

- Based on selection i want to load qvd file. If user selects only one value we can store that value in one variable and we can use that variable in where condition of qvd file. If user selects multiple values also we can store in a single variable but, how can apply this variable in where condition of qvd file.

For Eg:

LOAD A,

     B,

     C,

     D

FROM

Table1.qvd

(qvd)

WHERE(B = 1);

- i need to apply like this for all fields.

- For your reference i'm attaching my qvw file also.

[jagannalla]

Hi qliksus,

I need small help from you again. I'm storing all captureDateTime field data of in one variable(i.e vTotalDates=07-01-2011,07-02-2011,07-03-2011,07-05-2011,07-06-2011,07-07-2011,07-08-2011,07-09-2011,07-10-2011). While loading the qvd file i'm writing where condition like this.

where Match(CaptureDateTime,'$(vTotalDates)');

But it is not working .....can you plz help me once again