Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
khasimvali85
Creator II
Creator II

Display only Useful Columns in Tables?

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.

5 Replies
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

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

HI,

Try like this

Straight Table:

Dimension: CODE

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

Hope this helps you.

Regards,

Jagan.

manuelreimitz
Partner - Contributor III
Partner - Contributor III

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
Creator
Creator

!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
Creator II
Creator II
Author

Dear Pandiarajan,

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

    

Regards,

Khasim.