Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

RE:column Names

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.

1 Solution
10 Replies
sunny_talwar

Create an inline table in the script?

Load * Inline [

Dim

Region

Country

District

];

Chanty4u
MVP
MVP
Author

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
MVP
MVP
Author

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
MVP
MVP
Author

any sample qvw ?

Chanty4u
MVP
MVP
Author

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.