RE:column Names

[Chanty4u]

Hi all,

I have stright table and   i have 3 dimensions

Region               country        district

south                india               Ap

north                 Africa               KA

east                  USA                    MI

my requirment is   i need    dimension name as listbox .   like below

Listbox

Region

Country

Note:  i need only some of the columns only not all.

[sunny_talwar]

Create an inline table in the script?

Load * Inline [

Dim

Region

Country

District

];

[Chanty4u]

Hmmm     how it will be mapped ?   if do the selection is it reflect? i need mapping also  .

[sunny_talwar]

Use conditional hide and show may be? or use CrossTable load and then convert Region, Country and District into a single field. And use this in a pivot table

[Chanty4u]

No i already have pivot table with  6dimesnions  which  will not change anymore  bro

i need as stright table only

[sunny_talwar]

Then hide show your dimensions based on selection in Island table field just like shown here:

Customizable Straight Table

[Chanty4u]

any sample qvw ?

[sunny_talwar · Accepted solution]

jagan‌ worked on this:

Adhoc reporting in Qlikview

[Chanty4u]

but if i want only two  column names how to restrict  ?  like only  city and region

[sunny_talwar]

Select City and District in your island table list box.