Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

question about data retrival

I'm currently working on a project using the .net SDK qlik engine for my boss and he wants me to try and do something that I'm not sure is possible.  We've been using qlik to retrieve data from our server and display it in reports that have a nice static layout and everything's been going just fine, but I've hit a small road block with my latest adventure.  We have a report that is 100% dynamic between the order of the columns on the page to the types of columns that can appear in the report such as report one could be columns {A,B,C,D} while report two could be {A,D,C,B} and report 3 could be {X,A,B,Y}.

Is it possible to retrieve data from Qlik without using an object? Such as can I apply filters to the app and just pull the possible values that weren't filtered from the fields their selves?

In my previous attempts I would just recreate the report in Qlik using an object and pull that data back out from that and feed it into the program.

The solution I'm more leaning towards is just having my code create a new sheet with a new table it in on the fly with the dimensions and  measures that would be needed on the fly and afterwards delete the sheet if the client doesn't want that particular report saved.  The only issue I have then is working out how to correctly get that newly created table to get the correct column order.

Any suggestions and pointers would be welcomed with this, and if you need more information for clarification just ask and i'll try my best to explain better if possible.

1 Solution

Accepted Solutions
Not applicable

Re: question about data retrival

Thank you for the effort on this but it seems my manager after a talk has decided to go down a different path that will be a tad bit easier to do so I'm going to close this out as being resolved-ish i guess.

2 Replies

Re: question about data retrival

Maybe the use of variables instead of fields within a permanent object could be helpful, like:

Dim1 = $(vDim1)

Dim2 = $(vDim2)

....

and you set the variable-values in a order like you want - maybe with a further extension like $(vDim1Visible) to control also the visibility for the case that the number of dimensions could be vary.

- Marcus

Not applicable

Re: question about data retrival

Thank you for the effort on this but it seems my manager after a talk has decided to go down a different path that will be a tad bit easier to do so I'm going to close this out as being resolved-ish i guess.

Community Browser