Display only Useful Columns in Tables?

[khasimvali85]

Hi Community,

                    I wanna Display Except given mention rows  in Table?

Example:

CODE:

--------

ABCD

SCDG

DEMO

HGHG

WERU

INST

HJSK

YTIR

INGT

In the Above Example i wanna display Except These rows DEMO,INST&INGT.

any body have the solution Please provide me.

Regards

Khasim.

[phaneendra_kunc]

if you want to restrict in the table itself you can do a where clause in load script.

where not match(YourField,'DEMO','INST','INGT')

If in the UI you can write set analysis In chart expression

Sum({<YoutField-={'DEMO','INST','INGT'}>} FactColumn)

[jagan]

HI,

Try like this

Straight Table:

Dimension: CODE

Expression: Sum({<CODE={'DEMO','INST','INGT'}>} FactName)

Hope this helps you.

Regards,

Jagan.

[manuelreimitz]

in case of dynamic valuelist use "concat".

jagan mohan schrieb:

HI,

Try like this

Straight Table:

Dimension: CODE

Expression: Sum({<CODE={'DEMO','INST','INGT'}>} FactName)

Hope this helps you.

Regards,

Jagan.

Sum({<CODE={concat(Values, ",")}>} FactName)

[pandiarajan]

!Dear Khasim,

     your can handle two kind of approach

1) Using Setanalysis

2) Loading script itself you can make one flag column then you can use that flag column in your expression

script expression like that:

IF(CODE="DEMO" OR CODE="INST" OR CODE="INGT",1,0) AS validflag

UI Expression

sum({<validflag={1}>} factvalue}

[khasimvali85]

Dear Pandiarajan,

                         Thanks all of you for giving me Helpful Answers and  pandiarajan your expression is helpful for me.

Regards,

Khasim.