topic Re: How can i filter the data in QlikView

How can i filter the data

Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

Column 1	Column 2
A	1
B	2
C	3
D	4
E	5
F	6
G	7

From Column 1 i just want to see A, B, C in the report.

So how can i filter the data ? Where i need to write the expression ? And can you please provide me the expression ?

Please help

Thanks.

Re: How can i filter the data

Anonymous — Mon, 01 Aug 2016 10:57:25 GMT

you can use calculated Dimension: if match(Column1,'A','B','C')> 0, Column1)

set analysis

sum({<Column1={'A','B','C'}>}Column2)

Re: How can i filter the data

trdandamudi — Mon, 01 Aug 2016 10:59:59 GMT

Please see the attached for the solution:

Re: How can i filter the data

Mon, 01 Aug 2016 11:00:15 GMT

you can use the calculated dimension in this case in front end. in dimesion you can write expression as below:

if(match(Column1,'A','B','C'),Column1)

then check option to supress null values.

But it is better to do this at script level if possible or else create a flag in script for values as A, B and C and use this flag in calculated condition. it will be better performance wise as compare to above solution

Re: How can i filter the data

miguelbraga — Mon, 01 Aug 2016 11:04:26 GMT

See the attached file

Regards,

Re: How can i filter the data

Mon, 01 Aug 2016 12:17:37 GMT

Try this girishinani

Dimension : Column1

Expression :sum({<Column1={'A','B','C'}>}Column2)