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
sasikanth
Master
Master

Hi,

If possible please share your app

jagan
Luminary Alumni
Luminary Alumni

What is the issue?  The attachment which I shared earlier is working as expected.

Regards,

jagan.

settu_periasamy
Master III
Master III

Hi Suresh,

Check the Attachment (Source :Whats New in Qlikview 11)

I just modified some expressions only. Let us know, if this is what you are looking..



Chanty4u
MVP
MVP
Author

tq setu....it seem somewat same as per my req...

because i hve listbox wit dimensions only and

only one exp : count(Id)

?

Chanty4u
MVP
MVP
Author

dat was tried still nt wrkng balraj

settu_periasamy
Master III
Master III

Then you can Uncheck 'Conditional' in the expression. (speaks about my attachment).

It will show always 6 dimension with your expression. And it will show the dimension, based on your listbox selection.

Chanty4u
MVP
MVP
Author

even though its nt wrkng setu.

Chanty4u
MVP
MVP
Author

in expression tab...conditional.

=SubStringCount(Concat(_dimension, '|'), 1)and GetSelectedCount(_dimension)>0

i hve used dis....its nt wrkng?

what i need to gve dimension name in both? as bolded place

sasikanth
Master
Master

HI,

dimensions:

Dont write any conditional statements for 6 Fileds  and

If you have only one expression then do not enable it as conditional .

PFA

jagan
Luminary Alumni
Luminary Alumni

Hi Suresh,

Use below

=SubStringCount(GetFieldSelections(_dimension, '|'), 'Field Name', 100)


Regards,

Jagan.