topic Re: Change QVD dropdown in QlikView

Change QVD dropdown

Mon, 07 Jul 2014 09:52:31 GMT

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

Re: Change QVD dropdown

its_anandrjs — Mon, 07 Jul 2014 10:01:31 GMT

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.

Re: Change QVD dropdown

Gysbert_Wassenaar — Mon, 07 Jul 2014 10:06:46 GMT

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.

Re: Change QVD dropdown

its_anandrjs — Mon, 07 Jul 2014 10:10:40 GMT

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;