topic Re: Straight table not showing values correct? in QlikView

Straight table not showing values correct?

Tue, 01 Apr 2014 10:12:53 GMT

Hi,

I have a straight table which is getting data from excel sheet. in the excel I have three Members. But in the straight btable it is showing only two members. Please can any one help me?

Thanks.

Re: Straight table not showing values correct?

Tue, 01 Apr 2014 10:13:04 GMT

Please see attached.

Re: Straight table not showing values correct?

Tue, 01 Apr 2014 10:18:04 GMT

Please see attached excel also

Re: Straight table not showing values correct?

its_anandrjs — Tue, 01 Apr 2014 10:19:38 GMT

Your straight table is not properly visible click on last and drag it down. Third row is not visible arrange your straight table then it will visible to you and data is right.

Hope this helps

Re: Straight table not showing values correct?

Tue, 01 Apr 2014 10:23:25 GMT

Thanks. But the data is not correct for member 'Sein' as in excel the count for 'Sein' is 21. There are two instance of IDs S02146 with different dates. this is the problem. How can I show two IDs by using Distinct?

Re: Re: Straight table not showing values correct?

jsingh71 — Tue, 01 Apr 2014 10:27:33 GMT

It's Showing correct data for me. I didn't verified through excel but it showing all three members for me.

Find attachment.

--Jai

Re: Straight table not showing values correct?

Tue, 01 Apr 2014 10:32:36 GMT

Thanks. It is showing correct when I use Date or ID in straight table. But I don't want to use Date or ID. I just need the count. Please help.

Re: Straight table not showing values correct?

jsingh71 — Tue, 01 Apr 2014 10:35:49 GMT

Tell me dimensions and expressions what you want to show in your report.

--Jai

Re: Straight table not showing values correct?

Tue, 01 Apr 2014 10:37:39 GMT

I want to show

Dimension: Member

Expression 1(Number Review):

Count({<[Overall Result]={'Fail'}>} Distinct ([ID]))+

Count({<[Overall Result]={'Pass'}>} Distinct ([ID]))

Expression 2(Fail): Count({<[Overall Result]={'Fail'}>} Distinct ([ID]))

Expression 3(% of Fail): [Fail]/[Number Review]

Re: Straight table not showing values correct?

arjunkrishnan — Tue, 01 Apr 2014 10:41:47 GMT

Hai Amelia D,

Now All Three Member Show The Output In Straight Table ... U Just Check It out

Re: Straight table not showing values correct?

Tue, 01 Apr 2014 10:46:10 GMT

Thanks. One record is missing. Actually for Sein there are 21. Is there anything I need to change?

Re: Re: Straight table not showing values correct?

jsingh71 — Tue, 01 Apr 2014 11:00:59 GMT

Hi,

Find attachment, its showing corrrect data for me.

-- Jai

Re: Straight table not showing values correct?

arjunkrishnan — Tue, 01 Apr 2014 11:01:19 GMT

Nothing To Change in Straight Table.. It Little Bit Hide On Ur Table

Re: Straight table not showing values correct?

Tue, 01 Apr 2014 11:06:13 GMT

Sorry. I need both

If(Overall Result='Fail' Count (Distinct(ID))+

If(Overall Result='Pass' Count (Distinct(ID)) it should show 21 for Sein

but this is not working. Please any solution.