Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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;