topic Re: 4 Column Table Chart from 2 Column Source Data? in QlikView

4 Column Table Chart from 2 Column Source Data?

reanfadyl — Thu, 26 May 2016 09:02:11 GMT

Hi Folks,

I am trying to turn a 2 Column source table, into a 4 column chart in the following layout. The number of columns in the output table will vary according to selections. The reason is to use the chart in a PDF report that can be used to print labels, on preformatted sticker sheets.

Any ideas?

Thanks in advance

Rean

Re: 4 Column Table Chart from 2 Column Source Data?

Thu, 26 May 2016 09:09:01 GMT

You can create two charts and place them side by side.

i dont think it is possible to split tables in Qlik

Re: 4 Column Table Chart from 2 Column Source Data?

reanfadyl — Thu, 26 May 2016 09:14:59 GMT

Yes, two charts would do it. But how would the charts know which records to include?

Re: 4 Column Table Chart from 2 Column Source Data?

jonathandienst — Thu, 26 May 2016 09:21:34 GMT

You will need twp charts. You can then use calculated dimensions in the the following pattern to select the values for each table:

=Aggr(If(Rank(-<...expression...>) <= 5, <...dimension...>), <...dimension...>)

=Aggr(If(Rank(-<...expression...>) > 5 And Rank(-<...expression...>) <= 10, <...dimension...>), <...dimension...>

The ranking will allow for selection of some records in one table and some in another. You could rank by any attribute in your data, just insert he field name as the expression

Re: 4 Column Table Chart from 2 Column Source Data?

reanfadyl — Thu, 26 May 2016 09:44:48 GMT

Could the rank value be variable based on the number of rows selected? The sample was really just to show the layout I was after. It is going to be in the thousands of records.

Re: 4 Column Table Chart from 2 Column Source Data?

jonathandienst — Thu, 26 May 2016 11:20:00 GMT

Yes, you would need to work out the logic, but just replace the 5 and the 10 literals with expressions to calculate the numbers.