topic Re: Table Format in QlikView

Table Format

razvan_brais — Wed, 25 Nov 2020 16:16:04 GMT

Hy there. Is there any way to create a form that contains 4 tables? And I would like that the dimension for each panel to be dynamicaly.

Thank you.

Re: Table Format

robert_mika — Wed, 24 Aug 2016 07:27:49 GMT

You can use container for the table.

Could you be more specific about the dynamic dimension?

Re: Table Format

maxgro — Wed, 24 Aug 2016 07:47:09 GMT

I'm not sure to understand your question

You can try with a grid (2x2) container, like this

or nested container

Re: Table Format

razvan_brais — Wed, 24 Aug 2016 07:56:24 GMT

Thank you for your answer. When I said dynamic , I wanted to refer to the fact that I would like to set the dimension for each panel after each total value. So , a person has a total of 1000000$. And this total is divided in 4 categories , let`s say D = 500000 , C= 300000 , B=50 000 and A= 150 000 , i would like to have this distribution :

So the size of each pannel should modify after each value that I will get.

Thank you.

Re: Table Format

razvan_brais — Wed, 24 Aug 2016 09:15:47 GMT

What I exemplified in my upper comment is ok? Did you understood what I want to do?

Re: Table Format

Wed, 24 Aug 2016 09:19:45 GMT

Will you put different tables in those panels, or just color the panels? Are you looking for a Block chart?

Re: Table Format

yasmeenk — Wed, 24 Aug 2016 09:26:22 GMT

Hi Razvan,

Are you asking for block Chart?

Re: Table Format

razvan_brais — Wed, 24 Aug 2016 11:23:47 GMT

Yes , I would like to use Block Chart. But I have a problem. In that block chart I want to show different totals for one client. So , for dimension I have ClientID , and in expressions I have 4 different sums. But what I get is only one total. What am I doing wrong?

Thank you.

Re: Table Format

yasmeenk — Wed, 24 Aug 2016 12:47:04 GMT

Block Chart allows only one expression, so you can perform all your 4 different sums by separating with "&" in the expressions.

Re: Table Format

razvan_brais — Thu, 25 Aug 2016 06:23:35 GMT

Hello ,

Thank you for your answer. I tried to write the expression as you said. But it shows No data to display.

I wrote it like this : =(sum(Column1) & sum(column2). I guess there is something that I`m doing it wrong.

Re: Table Format

qlikviewwizard — Thu, 25 Aug 2016 08:39:22 GMT

Can you attach the sample file?

Re: Table Format

yasmeenk — Thu, 25 Aug 2016 08:48:46 GMT

What does the Column (1) and column(2) denotes?

Block chart displays only one expression, So you can calculate totals for each measure within an expression.

Re: Table Format

razvan_brais — Thu, 25 Aug 2016 09:44:01 GMT

Both Column1 and Column2 represents a number value(something like sales). But Column1 is from Table1 and Column2 is from Table2. Both tables are linked by a primary key (ClientID).

Re: Table Format

yasmeenk — Thu, 25 Aug 2016 10:09:56 GMT

Could you post your Expression?

Re: Table Format

razvan_brais — Fri, 26 Aug 2016 10:39:03 GMT

=(sum(VALOARE_SOLD_UF) & sum(CONTRACT_AMOUNT)

This is the expression that i`m using.

Re: Table Format

yasmeenk — Fri, 26 Aug 2016 12:54:51 GMT

Hi Razvan,

Try the expression with dual function as I posted above.

Re: Table Format

razvan_brais — Fri, 26 Aug 2016 13:35:00 GMT

Nope , still not working. But I quited trying using Block Chart. In my case is better to use pie chart. But thank for trying to help.