Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

khasimvali85
Contributor 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
Valued Contributor III

Re: Display only Useful Columns in Tables?

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)

Highlighted
MVP
MVP

Re: Display only Useful Columns in Tables?

HI,

Try like this

Straight Table:

Dimension: CODE

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

Hope this helps you.

Regards,

Jagan.

manuelreimitz
New Contributor III

Re: Display only Useful Columns in Tables?

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
Contributor

Re: Display only Useful Columns in Tables?

!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
Contributor II

Re: Display only Useful Columns in Tables?

Dear Pandiarajan,

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

    

Regards,

Khasim.

Community Browser