topic Re: How to get data from excel to straight table in QlikView

How to get data from excel to straight table

bharatkishore — Mon, 10 Dec 2012 06:51:14 GMT

Hello All,

I have an excel file data which is attached below. In that Excel sheet we have an field i.e. GVW_BAND. Now in that excel sheet under GVW_BAND we have an row i.e. 'ALL TONS'.

Now when i take a dimension GVW_BAND in straight table i am getting all rows except ALL TONS. Can any one please tell me how can i get that ALL TONS. That is the output i need to show.

But actually in my qvd if i take this GVW_BAND in a list box field only these values will be present.

Between 0 and 1

Between 1 and 5

Between 5 and 8

Between 8 and 16.20

Between 16.20 and 25

Between 25 and 32.20

Greater Than 32.20

So now i need one more i.e. 'ALL TONS' in that list box now i need total 8 in that GVW_BAND. Can anyone please tell me how to do.

Regards,

RBK

Re: How to get data from excel to straight table

Mon, 10 Dec 2012 07:27:54 GMT

we can create a calculated dimension in Stright table Like

if(GVW_BAND<>'ALL TONS',GVW_BAND)

~Kabilan K.

Re: How to get data from excel to straight table

bharatkishore — Mon, 10 Dec 2012 07:40:51 GMT

Thanks for the reply.

In my orginal data if i take GVW_Band field in list box i will get values like shown below

Between 0 and 1

Between 1 and 5

Between 5 and 8

So it will be containing upto Greater than 32.20(i.e. total 7 values)

Now i need one more that should be present with All Tons.

So now if i take this GVW_Band as a list box i need all the values including 'ALL Tons'(now total 8 values).

Re: How to get data from excel to straight table

Mon, 10 Dec 2012 08:48:18 GMT

Hi,

Pls Refer this Attachment..

Re: How to get data from excel to straight table

jagannalla — Mon, 10 Dec 2012 09:49:19 GMT

Hello,

May be this file will help you. Please check it.

Cheers!!

Jagan

Re: How to get data from excel to straight table

bharatkishore — Mon, 10 Dec 2012 09:53:31 GMT

Thanks a lot Jagan.

Regards,

R. Bharat Kishore

Re: How to get data from excel to straight table

bharatkishore — Mon, 10 Dec 2012 09:54:37 GMT

Thank you Kabilan.