Qlik Sense filter a table without aggregation

[Anonymous]

Hi all,

I am trying to filter a table to only display rows with an InputType of 'Error'. This is really easy to do by simply clicking the table and filtering that column by error. But I would like to permanently apply that filter to that table.

If I did it through set analysis it would aggregate the data which is what I don't want. Example data looks like:

Header 1	Header 2	Header 3	Header 4	Header 4
Date	Version	Site	Error	InputType
2017-12-09	2.5	AAA	Things broke	Error
2017-12-09	2.3	SSS	0.74	Stat
2017-12-07	2.3	BBB	0.65	Stat
2017-11-31	2.1	AAA	Something went wrong	Error

I would only like to show all the individual rows with InputType = 'Error'.

Any help would be much appreciated.

Thanks

[devarasu07 · Accepted solution]

Hi,

Method 1:Using back end script where clasue method

Fact:
LOAD * INLINE [
    Date, Version, Site, Error, InputType
    2017-12-09, 2.5, AAA, Things broke, Error
    2017-12-09, 2.3, SSS, 0.74, Stat
    2017-12-07, 2.3, BBB, 0.65, Stat
    2017-11-31, 2.1, AAA, Something went wrong, Error
] where InputType like '*Error*';

method 2: if it's only one chart object then u can create calculated dimension like below

=pick(wildmatch(InputType,'*Error*'),InputType)

make sure to suppress null value for this Cal.Dimension

Thanks,

Deva

[Anonymous]

Awesome, method 2 worked perfectly. Thank you.