Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Visual Ques Problem

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.

6 Replies
Employee
Employee

Re: Visual Ques Problem

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

v.jpg

Not applicable

Re: Visual Ques Problem

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.

visual.jpg

Employee
Employee

Re: Visual Ques Problem

Hi,

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

Bill

Not applicable

Re: Visual Ques Problem

Thank you Bill.

I'll waiting for your reply.

Have a nice day

Re: Visual Ques Problem

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

Not applicable

Re: Visual Ques Problem

Rob, I appreciate your tip. It works!!

I also think that may be a bug.

Thank you so much!

Community Browser