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