topic RE:stright table issue in QlikView

RE:stright table issue

Chanty4u — Wed, 06 Jan 2016 05:20:05 GMT

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

Re: RE:stright table issue

Anonymous — Wed, 06 Jan 2016 05:25:53 GMT

List Box with 10 Fields??

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

Re: RE:stright table issue

Chanty4u — Wed, 06 Jan 2016 05:27:55 GMT

sry 10 values

Re: RE:stright table issue

Anonymous — Wed, 06 Jan 2016 05:29:09 GMT

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

Re: RE:stright table issue

its_anandrjs — Wed, 06 Jan 2016 05:30:45 GMT

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

settu_periasamy — Wed, 06 Jan 2016 05:32:53 GMT

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

Re: RE:stright table issue

PradeepReddy — Wed, 06 Jan 2016 05:35:39 GMT

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

Re: RE:stright table issue

Chanty4u — Wed, 06 Jan 2016 05:40:59 GMT

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

Re: RE:stright table issue

jagan — Wed, 06 Jan 2016 05:41:24 GMT

Hi Suresh,

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

Adhoc reporting in Qlikview

Regards,

Jagan.

Re: RE:stright table issue

Chanty4u — Wed, 06 Jan 2016 05:44:52 GMT

for example...i have list box like belowso 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

Re: RE:stright table issue

Chanty4u — Wed, 06 Jan 2016 05:53:13 GMT

used this exp in dimension tab

settings for selected dimensions

=SubStringCount(Concat(_dimension, '|'), 'lFixTime')

Re: RE:stright table issue

PradeepReddy — Wed, 06 Jan 2016 05:55:37 GMT

if the selected fields/values should not visible in current selection box, use set hideprefix='_';

Re: RE:stright table issue

jagan — Wed, 06 Jan 2016 05:56:17 GMT

Hi Suresh,

PFA file for solution, Company and Id columns are shown by default, if any other fields are selected then those are shown in the report.

Regards,

Jagan.

Re: RE:stright table issue

settu_periasamy — Wed, 06 Jan 2016 05:57:36 GMT

may be, You can Uncheck the "Enable Conditional" for 6 default dimension

Re: RE:stright table issue

Chanty4u — Wed, 06 Jan 2016 06:04:27 GMT

i hve unchekd 6 dimensions....still its nt wrkng

Re: RE:stright table issue

jagan — Wed, 06 Jan 2016 06:07:40 GMT

Hi,

Did you got the answer?

Regards,

Jagan.

Re: RE:stright table issue

Chanty4u — Wed, 06 Jan 2016 06:10:17 GMT

no jagan..

Re: RE:stright table issue

shawn-qv — Wed, 06 Jan 2016 06:11:32 GMT

Select the 6 values you want selected by default. Then save your QVW file with those selections. If you don't have any macro/trigger that would clear that field, then those selections should hold when it's loaded (locally and on server).

** the default QlikView behaviour of the "check box style override" will automatically add new selection(s) to list.

Re: RE:stright table issue

Chanty4u — Wed, 06 Jan 2016 06:12:29 GMT

i have added all the dimensions and unchked the default 6 dimesions....and remaing all i wrote the exp abve i mentioned and enabled

Re: RE:stright table issue

Anonymous — Wed, 06 Jan 2016 06:12:46 GMT

like this?