Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

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

56 Replies
Chanty4u
MVP
MVP
Author

used this exp in   dimension tab 

settings for selected dimensions

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

PradeepReddy
Specialist II
Specialist II

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

jagan
Luminary Alumni
Luminary Alumni

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.

settu_periasamy
Master III
Master III

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

Chanty4u
MVP
MVP
Author

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

jagan
Luminary Alumni
Luminary Alumni

Hi,

Did you got the answer?

Regards,

Jagan.

Chanty4u
MVP
MVP
Author

no jagan..

shawn-qv
Creator
Creator

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.

S.

Chanty4u
MVP
MVP
Author

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

Anonymous
Not applicable

like this?