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

Many problems with a InputField try

Hello,

First, sorry for my english, this is a Google translation [:O]

For a client, a problem has come to me.

I am currently with version 9.00.7320.7 QV SR2 (but the example has
been reproduced on a SR4).
Windows XP SP3.

The application attached test.qvw illustrate the point. I will describe.

I originally created a field inputfield "ToComment.

I load a table inline with a key and a value.

Then I want to load another table "comments" related to previous by the same key. I created inline if it's the first times. My ToComment field is blank.

If there isn't the first time, I load my qvd which would contain key information / comment.

The QVD is created automatically by a macro using the property ServerSideExportEx from table TB02 (under the button)

Here are my questions:

1 / When I run the macro, I would specify a parameter that I want created a QVD. As indicated in the API Guide, I have to use the value 4
for achieving a qvd. He does not want it because three parameters is needed. I am willing to give three parameters. But after the name of
file and the file format, what other parameter to indicate? The best I could do it by taking the example of the API Guide and putting the 4. But I created a csv quite normal.

2 / This is THE great demand. So I start with anything. No comment. I type comment in one of the fields and runs the macro. My file (Falsely) qvd is created with the right values in the right places. I realize some other seizures. I save. The "qvd" is correctly created. If I empty and refill my application, Nothing to say.

I make the same action, I save, but before recharging I realize a sort of table TB02. Then the data are mixed. Visually, associations are made according to the chosen sorting ProduitPeriode and registration for ToComment.

Why? It's unbelievable ... My table gets yet Data_Comment values linking the two information correctly!

3 / I come to "correct" the previous point in creating another table (Here, the TB01). The TB01 will display, to sort ProduitPeriode, the TB02 keeping its reference function backup, without sorting it. And then everything goes well.

Except that if I insert a new value in my first table with a key Data ProduitPeriode that could go before (P0201005 example). The key is created but cell comment can not be completed (I get a cross on the graph as when a refusal to load the graph). I have to make the backup of my qvd
comments and again charge. Then I can edit.

Until then, I could say ok, it's not a problem. It does not capture because for him the field ToComment associated with this key does not exist. I understand.

But the problem is that behind when I reload, I found the same concerns in my point 2 /. The comments are shifted because my first line of "qvd" without comment.

Thancks in advance and don't hesitate to ask me your question !

1 Reply
Not applicable
Author

erf... up... ?