Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

3 Replies
Not applicable
Author

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

Not applicable
Author

you are right.

Not applicable
Author

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.

RR