topic select value from (multi box) then data automatically reflect into table box in QlikView

select value from (multi box) then data automatically reflect into table box

Wed, 08 Dec 2010 12:14:04 GMT

OLEDB CONNECT32 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=tme;Data Source=OLISTADB_INT;Extended Properties=""] (XPassword is SFCSAaVNFLCA);

test:
SQL SELECT * FROM summary_pcs;

//store Qlikview Table from memory to disk

store test into E:\qlikview\test.qvd (qvd);

LOAD
EVENT_DATE , sum(APC_QUERY_NOT_OK_COUNT)
FROM test.QVD (QVD)
group by EVENT_DATE ;

************************

question

========

if i select chargingprofileid(here 15) from layout(multi box) then it will automatically reflect into table box properties.

how will i do this?

it is working when i select event date from multibox.

please help me out............

select value from (multi box) then data automatically reflect into table box

Wed, 08 Dec 2010 13:36:52 GMT

Hello abcd1234,

my first assumption is that you do not have a link (or let's say a path) from your field "chargingprofileid" to any of your fields in your shown table box. To clearify that please post your data modell (via table viewer using crtl T).

Regards, Roland

select value from (multi box) then data automatically reflect into table box

Wed, 08 Dec 2010 13:43:30 GMT

you are right.

select value from (multi box) then data automatically reflect into table box

Thu, 09 Dec 2010 09:59:42 GMT

So you have to find a connection between them. QV will connect two tables with two different fields, when the fields have same names (ie. by renaming input fields). For example: Calender.Month and Facttable.Month will be the linking edge between the tables calender and facttable. If you are able to send a data model we can discuss it in more detail and more practical.