topic Re: Display only Useful Columns in Tables? in QlikView

Display only Useful Columns in Tables?

khasimvali85 — Fri, 10 Oct 2014 06:27:29 GMT

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.

Re: Display only Useful Columns in Tables?

phaneendra_kunc — Fri, 10 Oct 2014 06:48:56 GMT

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)

Re: Display only Useful Columns in Tables?

jagan — Fri, 10 Oct 2014 07:07:45 GMT

HI,

Try like this

Straight Table:

Dimension: CODE

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

Hope this helps you.

Regards,

Jagan.

Re: Display only Useful Columns in Tables?

manuelreimitz — Fri, 10 Oct 2014 07:13:04 GMT

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)

Re: Display only Useful Columns in Tables?

pandiarajan — Fri, 10 Oct 2014 07:22:37 GMT

!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}

Re: Display only Useful Columns in Tables?

khasimvali85 — Fri, 10 Oct 2014 08:35:33 GMT

Dear Pandiarajan,

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

Regards,

Khasim.