topic Re: How to create simple table in Qlikview? in QlikView

How to create simple table in Qlikview?

nehasaxena — Tue, 03 Dec 2013 07:26:02 GMT

Hi,

I need to create a simpletablw in Qlikview. I tried to do this by creating straight table or Pivot table but its not working because my table has repeated values. In pivot/straight it is displaying in aggregated form.

I have attached the original table.

Kindly help. Its very urgent for me.

Thanks in Advance!!

Re: How to create simple table in Qlikview?

Tue, 03 Dec 2013 07:33:32 GMT

Hi Neha,

Please try creating a table box object which can solve this problem.

Thanks,

Sai

Re: How to create simple table in Qlikview?

rustyfishbones — Tue, 03 Dec 2013 08:15:04 GMT

You can create a table box by clicking this icon

Just select the dimensions you want from the available fields

Re: How to create simple table in Qlikview?

Peter_Cammaert — Tue, 03 Dec 2013 08:23:40 GMT

Do not use a table box if you want to keep all duplicate value sets.

First in your load script, add the value of RowNo() as a field to your LOAD statement. This field will contain the number of the row in the internal table (starting from 1) and will respect the load order.

Then create a straight table, add all required fields (including the field containing RowNo values) as dimensions and add a dummy expression like '=1'. Sort on ascending RowNo values. You can 'Hide' the expression column if you want (see Properties->Presentation)

Every individual record that was loaded in your script will be shown in order.

Best,

Peter

Re: How to create simple table in Qlikview?

nehasaxena — Tue, 03 Dec 2013 11:46:54 GMT

thanks all for reply !!

I have created 1 table box but is it possible to change the display of table box. I mean it will show that repetitive value only 1 time in the box.

Re: How to create simple table in Qlikview?

Clever_Anjos — Tue, 03 Dec 2013 11:53:48 GMT

If must include a column that is not repeated.

If you don´t have one into your datamodel, use Peter suggestion

Re: How to create simple table in Qlikview?

nehasaxena — Tue, 03 Dec 2013 12:06:24 GMT

ya i tried to do the same.. created 1 table box and hide the expression and row no but repeatition is still there. I mean is there any option in straight or pivot which is not in table box to hide these repetition.

Re: How to create simple table in Qlikview?

nehasaxena — Tue, 03 Dec 2013 12:21:53 GMT

Its working in Pivot view.. and we can hide the expression column( =1) by minimize the col width and removing label from expression.

Re: How to create simple table in Qlikview?

Peter_Cammaert — Tue, 03 Dec 2013 12:27:24 GMT

You cannot hide columns in Pivot Tables. Use a Straight Table instead.

Peter

Re: How to create simple table in Qlikview?

saumyashah90 — Tue, 03 Dec 2013 12:31:47 GMT

You Cannot hide columns in Pivot table

So better you use Straight Table

Re: How to create simple table in Qlikview?

gandalfgray — Tue, 03 Dec 2013 12:39:55 GMT

If you only want each combination once, use a table object, and do not include the rowno field!

Re: How to create simple table in Qlikview?

Peter_Cammaert — Fri, 06 Dec 2013 08:59:48 GMT

Please close the dicussion by marking a reply as an Answer. That makes it easier for us to track unanswered questions. Thanks.

Peter