Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Chanty4u
Esteemed Contributor III

RE:stright table issue

hi all,

I have small issue.

I have one list box wit  10fields

and i hve one stright table aswell.

my req is:   only 6fields shud be shown default in stright table evry time.

and when even we select other value in listbox it shud be add in stright table...?

is this possible? help me out any one?

thanks in advance

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: RE:stright table issue

Hi,

Remove the default fields from the list box from the below inline table in your script

Dimensions:

LOAD * INLINE [_dimension

'

'

'

'

'

'

'

'

];

Regards,

jagan.

56 Replies
balrajahlawat
Esteemed Contributor

Re: RE:stright table issue

List Box with 10 Fields??

Are you sure, can we have 10 fields in a list box?

Chanty4u
Esteemed Contributor III

Re: RE:stright table issue

sry 10 values

balrajahlawat
Esteemed Contributor

Re: RE:stright table issue

How would you differentiate which 6 values of a list box should come?

Re: RE:stright table issue

Possible with if condition can you please provide logic for that and put it on the list box expression.

Regards,

Anand

Re: RE:stright table issue

Hi suresh,

I have one list box wit  10fields

I believe you are talking about data island of Dimension / Metric Fields.

And you want to display the fields should be in dynamic. If so,

You can look :

C:\Program Files\QlikView\Examples\Documents\Whats New in QlikView11.qvw

In the Report tab, there is dynamic chart

pradeepreddy
Valued Contributor II

Re: RE:stright table issue

Select the initial 6 fields, you want to showcase in straight table. Then choose 'Set Clear State' option...

Chanty4u
Esteemed Contributor III

Re: RE:stright table issue

wen i set clear state ....it shwng as  selected values in list box.......i dnt want to highlght in listbox.

MVP & Luminary
MVP & Luminary

Re: RE:stright table issue

Hi Suresh,

Not sure about your requirement, if you are looking for Adhoc reporting then check below link

Adhoc reporting in Qlikview

Regards,

Jagan.

Chanty4u
Esteemed Contributor III

Re: RE:stright table issue

for example...i have list box like belowdef.pngso in that list box i need to set six values as default shwn in stright table....and wen i select one more value in listbox it shud be add