topic Re: Visual Ques Problem in QlikView

Visual Ques Problem

Mon, 26 Jan 2026 18:19:17 GMT

Hello.

I have a problem, when i use pivot table.

Assume that there is a Dimension Table A, and Fact Table B.

==================================================

Table A

[DimensionA, DimensionB]

Table B

[DimensionB, Value1, Value2, ...]

Table A and Table B Linked by DimensionB.

==================================================

When I use visual que option that 10 byte number (ex. 10000000000), it was not work.

I attach the file.

Thanks.

Bill_Britt — Tue, 27 Nov 2012 13:56:16 GMT

I checked you file and I don't see or I don't understand the problem.

Wed, 28 Nov 2012 01:52:18 GMT

HI, Bill. I really appreciate to your reply.

you only check 1 sheet. first sheet is ok. but the problem occur second sheet.

First sheet use only Table TEST1. It use dimesion and fact value in same table.

On the other hands Second sheet use Table TEST2 and TEST3. it has relation column Org22.

I make straight table use demension Org11(TEST2), and fact value Value11, Value22, ,,,,(TEST3)

Please See Sheet2.

Thanks.

Bill_Britt — Wed, 28 Nov 2012 17:44:28 GMT

Hi,

I would contact support and let them open a case to see if this is a bug or not.

Bill

Thu, 29 Nov 2012 00:34:55 GMT

Thank you Bill.

I'll waiting for your reply.

Have a nice day

rwunderlich — Thu, 29 Nov 2012 16:43:51 GMT

That may be a possible bug. I note that you can workaround the problem by uisng num() in the Visual Cue for the lower boundry:

=num(7000000000)

-Rob

Fri, 30 Nov 2012 07:15:17 GMT

Rob, I appreciate your tip. It works!!

I also think that may be a bug.

Thank you so much!