Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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
Partner

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

HI,

Try like this

Straight Table:

Dimension: CODE

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

Hope this helps you.

Regards,

Jagan.

manuelreimitz
Partner
Partner

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.