topic Re: Straight table column problem in QlikView

Straight table column problem

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

Hi qliks,

We have a straight table which has around

74 columns. It displaying data.

But when I added a new column table is not displaying any data. I mean it's blank. After removal of new column table is displaying data.

What could be the possible reasons for this.

Is there any limitations to straight table

Re: Straight table column problem

its_anandrjs — Thu, 19 Oct 2017 15:34:38 GMT

Check this field which you adding on the chart has a proper connection in the data model or not. Or you can go for checking Slowly Changing Dimension (

Read Some of this

Slowly Changing Dimensions

Slowly Changing Dimension logic in QlikView | Qlik Community

IntervalMatch and Slowly Changing Dimensions

Re: Straight table column problem

stonecold111 — Thu, 19 Oct 2017 16:51:57 GMT

No it's not realted to slowly changing dimensions

If I add any column,chart doesn't show any data.

When I remove new column,table is displaying data

Re: Straight table column problem

MK9885 — Thu, 19 Oct 2017 17:26:58 GMT

If your straight Table is not using any expressions then use 'Table Box'

It also have scroll option unlike Straight Table

Re: Straight table column problem

stonecold111 — Fri, 20 Oct 2017 04:54:41 GMT

Thanks... But I already know that

We are using straight table for future purpose

We need to do enhancements on that table

What I want is why my straight table is going blank for just one new column

Re: Straight table column problem

mithilesh17 — Fri, 20 Oct 2017 05:31:59 GMT

Dear Suresh,

Field which you have added is in dimension or measure?

Kindly share sample app if possible.

Regards,

Re: Straight table column problem

ramasaisaksoft — Fri, 20 Oct 2017 05:47:36 GMT

Hi Suresh,

As we already know S.table will show the data in detail format.

Reason 1:-

May be your Measure is won't support/associated with newly added dimension

Reason 2:-

Ex:- Account wise transactions

ACC No Trans ID Amt

1 1 100

1 2 200

1 3 500

per suppose you added a new Dimension like (Sum(Amt)) as "Remaining balance"

now the chart will confuse for the aggregation function & it won't show any data..

etc...

Re: Straight table column problem

jonathandienst — Fri, 20 Oct 2017 05:50:26 GMT

First create a new table. Add the dimensions and 2-3 of the working expressions. Then add the "problem" expression and see what happens. If it displays correctly, perhaps the other table has gotten a little corrupted. If that is the case, recreate the table.

Otherwise, I suggest that you upload a small sample that illustrates the problem. It should have sufficient data and the two copies of the table that is behaving this way (one without the problem expression and one with it). That way, we can diagnose the problem and perhaps suggest solutions.

Anything else is guesswork.

Re: Straight table column problem

stonecold111 — Fri, 20 Oct 2017 06:09:21 GMT

It is dimension not expression

For now we don't have any expression s

Re: Straight table column problem

stonecold111 — Fri, 20 Oct 2017 06:10:58 GMT

Sharing is not possible.

It's dimension and don't have any expression s

And I don't want to use table box

Re: Straight table column problem

stonecold111 — Fri, 20 Oct 2017 06:12:11 GMT

You maybe right . I will create new table and check

Re: Straight table column problem

stonecold111 — Fri, 20 Oct 2017 06:17:47 GMT

New dimension that I'm adding is date field with timestamp.

Maybe that is the reason table can't display data

Re: Straight table column problem

stonecold111 — Fri, 20 Oct 2017 06:20:53 GMT

I just added that date with timestamp field with other 2 or 3 columns and it's displaying data.

Maybe straight table unable to fetch large amounts of data

Re: Straight table column problem

stonecold111 — Fri, 20 Oct 2017 06:22:14 GMT

And it will work with sample data as it is small

I already told to you that it has 74 columns and no expression.

Re: Straight table column problem

jonathandienst — Fri, 20 Oct 2017 06:29:21 GMT

If your table has 74 dimensions, you may simply be running out of memory, or hanging due to the complexity of the calculation. That is a staggering amount of dimensions...

Re: Straight table column problem

Anil_Babu_Samineni — Fri, 20 Oct 2017 06:32:29 GMT

In my way i came with some thoughts

1) May be Limited columns in Tablebox - But, I don't think limit is the problem because we can use number of columns if we have enough RAM and CPU as specification required

2) Here, I was thinking about data immigrant which has unique granularity cells of each columns. Let's consider as 3rd one

3) When we have some unique rows which is not there of another table called immigrant

4) Let's discuss, with example - If we are adding 3 columns each with 20 distinct values then qlik products calculate as 20*20*20 that means the rows efficient and increasingly.

5) What you think when you have 73 columns with 100 distinct values? Does it make sense to calculate each 100*100*100....power of 73 time as Qlik calculates. do you know what does value indicated it extend to around 1e+148 times?? So, For this i think you need Trillion GB of RAM for sure.

5) so, to resolve this issue i would always prefer to think measure (expression). Why are you using for dimensions as we have metric level aggregation to calculate

Does this helps to you?

Re: Straight table column problem

stonecold111 — Fri, 20 Oct 2017 06:35:39 GMT

Yes you are right. When I add other new column with less data. It's displaying data. But when I add date with timestamp column it's going blank.

What I have to do now

Re: Straight table column problem

stonecold111 — Fri, 20 Oct 2017 06:38:03 GMT

It's because of timestamp and number of unique values are more. So it's unable to fetch data.

Re: Straight table column problem

stonecold111 — Fri, 20 Oct 2017 06:46:31 GMT

Hi anil,

I have 3 expressions. But I can calculate them in script level. So I changed those 3 expressions also to dimensions

Recently we changed another column to timestamp format. Now it's the second column we are adding timestamp format. And I calculated count of that field

It has 5131 unique values

Chart is going out of memory as Jonathan suggested

Re: Straight table column problem

Anil_Babu_Samineni — Fri, 20 Oct 2017 06:56:22 GMT

If you read my bullet points where 4th and 5th you will get some idea...