topic Re: RE:column Names in QlikView

RE:column Names

Chanty4u — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: RE:column Names

sunny_talwar — Wed, 21 Dec 2016 17:17:11 GMT

Create an inline table in the script?

Load * Inline [

Dim

Region

Country

District

];

Re: RE:column Names

Chanty4u — Wed, 21 Dec 2016 17:25:15 GMT

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

Re: RE:column Names

sunny_talwar — Wed, 21 Dec 2016 17:26:45 GMT

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

Re: RE:column Names

Chanty4u — Wed, 21 Dec 2016 17:30:03 GMT

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

i need as stright table only

Re: RE:column Names

sunny_talwar — Wed, 21 Dec 2016 17:34:27 GMT

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

Customizable Straight Table

Re: RE:column Names

Chanty4u — Wed, 21 Dec 2016 17:38:29 GMT

any sample qvw ?

Re: RE:column Names

sunny_talwar — Wed, 21 Dec 2016 18:19:07 GMT

jagan‌ worked on this:

Adhoc reporting in Qlikview

Re: RE:column Names

Chanty4u — Wed, 21 Dec 2016 18:28:30 GMT

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

Re: RE:column Names

sunny_talwar — Wed, 21 Dec 2016 18:36:26 GMT

Select City and District in your island table list box.

Re: RE:column Names

Chanty4u — Wed, 21 Dec 2016 18:39:01 GMT

let me try bro