Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change QVD dropdown

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

3 Replies
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.


talk is cheap, supply exceeds demand
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;