Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
HI,
Try like this
Straight Table:
Dimension: CODE
Expression: Sum({<CODE={'DEMO','INST','INGT'}>} FactName)
Hope this helps you.
Regards,
Jagan.
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)
!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}
Dear Pandiarajan,
Thanks all of you for giving me Helpful Answers and pandiarajan your expression is helpful for me.
Regards,
Khasim.