Change QVD dropdown

[#1]

Hi all,

       I have seven differrent qvw files with same objects and same data model (Single Table) but with diffrent data.

now i need to show the data based on drop down select (or button select)

lets say the table structure is

Name

roll no

marks

for a.qvw  name  roll no   marks

                aaa    1          124

                bbb     2           155

for b.qvw  name  roll no   marks

                ccc      4         200

                ddd       5          100

if i select a.qww values

name  roll no   marks

                aaa    1          124

                bbb     2           155

needs to be populated on chart

values for a.qvw and b.qvw stored on different qvd files

[its_anandrjs]

Add Flag field in the load statement of the QVW like

Tablea:

load name,  [roll no],   marks, 'Table1' as TableFlag;

Load * Inline

[name,  roll no,  marks

aaa,     1,           124

bbb,     2,           155

];

Tableb:

Load name,  [roll no],   marks, 'Table2' as TableFlag;

Load * Inline

[name,  roll no,    marks

  ccc,      4,         200

  ddd,      5,         100

];

Do this for other tables and on front end plot field TableFlag if you want to see record of table 2 then select Table2 from the list.

[Gysbert_Wassenaar]

Load all the data in one table and add a field that contains the source of the data:

MyTable:

LOAD aaa, bbb, 'a.qvd' as Source from a.qvd (qvd);

LOAD aaa, bbb, 'b.qvd' as Source from b.qvd (qvd);

LOAD aaa, bbb, 'c.qvd' as Source from c.qvd (qvd);

Use the new Source field for the drop-down select.

[its_anandrjs]

You can use Filebasename( ) or FileName( ) functions also to find the table data and make field

Ex:-

Tablea:

load

name,

[roll no],  

marks,

FileName() as TableFlag

From Location;

Tableb: 

Load

name,

[roll no], 

marks,

FileName() as TableFlag

From Location;