topic Re: Straight table doesn't display values like Table box in QlikView

Straight table doesn't display values like Table box

Anonymous — Fri, 20 Nov 2020 18:02:30 GMT

Hi,

I am having an issue when I am using a straight table. What am I missing?

Data correctly displays fine in tablebox like below. Customer came on 2015-11-02 and left on 2015-11-05. Then came back on 2015-11-08 and left on 2015-11-10. Then came back on 2015-11-11.

ReVisit	OverRallID	Name	CheckIn	CheckOut
2015-11-08	100	Johnson,James	2015-11-02	2015-11-05
2015-11-11	100	Johnson,James	2015-11-08	2015-11-10

But in Straight table, it displays like below. It seems like it is confused since there are 2 revisits to pick from which will be 2015-11-08 and 2015-11-11. When I select 8th or 11th revisit date from the master calendar(day), then all values pops-up in the below straight table for that specific revisit. However, I want it to display all the rows like in table box above without me manually picking either 8th or 11th.

ReVisit	OverRallID	Name	CheckIn	CheckOut
-	100	Johnson,James-	-	-

I also confirmed that I have not checked "Supress when value is null". How can I fix this? I want to use the straight table so that I can add more calculated fields. Please assist. Thanks a lot.

Re: Straight table doesn't display values like Table box

Anonymous — Sun, 15 Nov 2015 00:43:36 GMT

I got it. I was using only OverRallID as the dimension but I added VisitID in the dimension as well and that did the trick. Since OverallID remains the same for the specific customer but VisitID changes every time they revisit. Just updating if anyone else comes across this issue. Thanks.

Re: Straight table doesn't display values like Table box

Kushal_Chawda — Sun, 15 Nov 2015 11:19:30 GMT

Awsome

Re: Straight table doesn't display values like Table box

rwunderlich — Sun, 15 Nov 2015 16:17:42 GMT

Go ahead and mark your own answer as correct to close the thread.

-Rob