topic Re: Qlik Sense Tables in App Development

Qlik Sense Tables

vinod_ramachand — Sat, 16 Nov 2024 18:29:35 GMT

Dear Experts.

First of all it took 5 minute to findout how to post a question in this platform. and secondly why qliksesne tables are so messy and nobody want's to use it

Example: here is a simple table, all I want is column headers at proper places. Becase nobody will understand at first galnce what columns refer to what. Please is there any way to have simple straight table like excel table?

Re: Qlik Sense Tables

Or — Sun, 14 Jun 2020 10:36:11 GMT

Use a straight table, instead of the pivot table you used.

Re: Qlik Sense Tables

vinod_ramachand — Sun, 14 Jun 2020 10:41:39 GMT

Thanks for your reply.

The table i showed is "Customer Statement", where i can't have repeated field value(if i use straight table) in rows

Regards

Re: Qlik Sense Tables

Or — Sun, 14 Jun 2020 11:11:40 GMT

Well your question was "Is it possible to have a straight table". You can't have a straight table if you use Pivot Table.

Some extensions exist which will cause a pivot table to be displayed in a manner that is more similar to a straight table (including with headers directly above the column they belong to), and some extensions exist which will cause a table to allow things like cell merging for identical dimension values, but this is not the Qlik Sense native default.

If you're interested in these extensions, you could have a look at the Vizlib library, which provides both of these functionality sets (Full disclosure: I am a Vizlib customer but I am not otherwise affiliated with Vizlib in any way). Other extensions may be out there which do the same thing.

Qlik has been making some improvements as to the overall handling of pivot tables in recent versions, so it's best to check the latest release (June 2020) to see if any functionality related to your requirement might be available in the native release.