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
jagan
Luminary Alumni
Luminary Alumni

Remove the Calculation Condition option in  General tab of the chart.  Now it will show all the default fields always.


Regards,

jagan.

Chanty4u
MVP
MVP
Author

yeah..jagan but  that fields shud nt shown in listbox which which we are used fr default table fields?

how it possible?

settu_periasamy
Master III
Master III

Hi Suresh,

You can also check my attachment.. I have excluded the default value from the listbox.

I used the expression like..

=if(_dimension<>'Address Number' 

and _dimension<>'City'

and _dimension<>'Country'

and _dimension<>'Customer'

and _dimension<>'Invoice Date'

and _dimension<>'Invoice Number',_dimension)

So, these values won't display..

tamilarasu
Champion
Champion

The below attachment is working fine against your initial question. It shows 6 default dimension and one metrics. When you select dimensions from list box, it's added in dimension tab.

jagan
Luminary Alumni
Luminary Alumni

Hi,

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

Dimensions:

LOAD * INLINE [_dimension

'

'

'

'

'

'

'

'

];

Regards,

jagan.

Chanty4u
MVP
MVP
Author

Awesome jagan.Thnx fr ur help.

Thanx to alll who given all ur efforts on this .

Thanks

Suresh

Chanty4u
MVP
MVP
Author

thnx settu,

i hve removed fileds in script level.