topic Re: QlikSense - Vertical Table in App Development

QlikSense - Vertical Table

Thu, 12 Jan 2017 13:38:07 GMT

Hi guys!

I'm hoping to tap into your vast knowledge.

I have a tab in Sense where I would like to display a summary of attributes for the specific selection, i.e. one row per field.

Using a table this results in each field being displayed horisontally and the data in a row beneath. Thus:

What I would like is to have it displayed like this:

Is there a way to do this in QlikSense? Have I missed something obvious?

Thanks, guys 😃

//Nathalie

Re: QlikSense - Vertical Table

Anonymous — Thu, 12 Jan 2017 13:40:36 GMT

I could not find a way of doing this with Out Of the Box QlikSense, so am writing an extension to do it.

Re: QlikSense - Vertical Table

Thu, 12 Jan 2017 13:46:57 GMT

OK, Bill! Keep me posted =).

Re: QlikSense - Vertical Table

petter — Thu, 12 Jan 2017 17:06:47 GMT

It is somewhat possible to do it in Qlik Sense with the normal table - not with dynamic number of columns though. So this might be too much of a hack for you - but it does work.

Create a variable like this:

='ValueList(' & Chr(39) & Concat( {<$Table={Sales}>} $Field ,Chr(39)&','&Chr(39)) & Chr(39) & ')'
The first column has to be this expression:
=$(SalesFields)
The second column has to be this:
=FieldValue($(SalesFields) , 1 )
The third column has to be this:
=FieldValue($(SalesFields) , 2 )
.... and so on ....

And you have to add the columns manually but just increase the second parameter by one for each new column.

The limitation is that there is no real sorting as every field value will come in load order as it is in your load script. Of course you can manually sort by doing the FieldValue index descending instead ....

Here is my [Sales] table flipped over:

An extension like Bill suggested would be easier to use... If you need something today that works and you can live with the limitations this recipe will work....

Re: QlikSense - Vertical Table

Fri, 13 Jan 2017 06:12:32 GMT

Hi Petter

Thanks! I only have the one column (after field name) for this so that could work a charm.

I got it working for the Field but not the content. The ressult looks like:

The settings:

Do you Think you can help me?

Cheers

//Nathalie

Re: QlikSense - Vertical Table

petter — Fri, 13 Jan 2017 13:15:32 GMT

It is important that you do step one in my recipe - create the variable Fakta_1 (in your case).

Did you do that?

The variable should be defined like this - I guess your table is called Fakta?

='ValueList(' & Chr(39) & Concat( {<$Table={Fakta}>} $Field ,Chr(39)&','&Chr(39)) & Chr(39) & ')'

Is it a count or sum you want to do for each Rubrik?

Re: QlikSense - Vertical Table

Wed, 01 Feb 2017 13:22:30 GMT

Hi Petter

Yes. All steps are accounted for =).

I only want to show the value for each field. The value is to 99% of the time non-numerical.

Re: QlikSense - Vertical Table

Thu, 02 Feb 2017 05:58:54 GMT

Hi!

I found my mistake.

I had made two semi-identical variables with the same name, which confused everything of course. Now it works perfectly. Thanks a bundle, Petter!

Re: QlikSense - Vertical Table

sskinner — Fri, 31 Jan 2020 19:08:07 GMT

Hi, I checked the Qlik Branch for something like this but could not find anything (?). This works very well, I just needed a little extra bit of functionality: the displayed 'row' to be based on current selections (most likely a single row). Conceptually something like;
=FieldValue($(SalesFields) , CurrentlySelectedRowNo() )

What I ended up doing to solve this is storing the RowNo in a field in the table (although I think it is in there already) and then doing this...
=FieldValue($(SalesFields) , Only({$}[KeyRowNoField]))

~~It seems to be working~~ 🙂~~. Just sharing in case it's of use or someone has a better way.~~ Update: which "almost" works; seems to not return all values. Could be my data...

Re: QlikSense - Vertical Table

kpradeep5610 — Fri, 13 Nov 2020 09:16:13 GMT

Hi Petter,

Excellent solution you are provided. but my requirement is if i select any field in that table it wont reflect to the table.

Re: QlikSense - Vertical Table

KasperJeppesen1 — Mon, 11 Jan 2021 17:42:14 GMT

Hi @Anonymous

Would you know if it possible to change the horisontal menu in a container to a vertical ? Like in the image below. with css ?

Thank you!

Re: QlikSense - Vertical Table

mshann01 — Thu, 23 Sep 2021 20:48:15 GMT

Any chance this extension ever made it to production? I can't find anything similar in the Qlik Garden