How to create simple table in Qlikview?

[nehasaxena]

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!!

[#2]

Hi Neha,

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

Thanks,

Sai

[rustyfishbones]

You can create a table box by clicking this icon

Just select the dimensions you want from the available fields

[Peter_Cammaert]

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

[nehasaxena]

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.

[Clever_Anjos]

If must include a column that is not repeated.

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

[nehasaxena]

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.

[nehasaxena · Accepted solution]

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

[Peter_Cammaert]

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

Peter

[saumyashah90]

You Cannot hide columns in Pivot table

So better you use Straight Table