How can show just specific items of on filed in table

[nazaninslp]

Dears

I want show just specific item in my Category fields, but I dont know how.

would you please help me in this regard.

for example in below chart I dont want show TEST and Sport items in chart.

how can omit them in expression part or other ways.

Thank you

[Or · Accepted solution]

You did not include your expression, so obviously it's a little hard to say..

Sum({<Category -= {'Sport','Test'}>} Revenue) would be the general direction though.

[nazaninslp]

Dear Or Shoham

Thanks for your answer

please find my chart details in below:

Dimensions:

     -     date_key

     -      Category

Expression :

- Sum(Revenue)

I've tried your expression , but I got error and nothis display in chart

would you please help?

[Or]

I double-checked my syntax and it is correct - that expression should work if your fields are named Revenue and Category.

LOAD * INLINE [

    Revenue, Category, Date

    100, Sport, 01/01/2018

    200, Test, 02/01/2018

    300, Other, 03/01/2018

    400, Other, 04/01/2018

    500, Sport, 05/01/2018

    600, Hello, 06/01/2018

    700, Sport, 07/01/2018

];

There might be something else getting in your way, but no idea what it might be without being able to see the actual file.

[nazaninslp]

Dear Or Shaham

many thanks

it works fine.

I have other question

I've limited to show just today value in chart like below , I want to omit Test and sport from it but I cant.

below just show today value, how can report test and sport category from it. (like previous one)

Expression : sum({<date_key={"$(=max(date_key))"}>}NEW_SUBSCRIPTION_COUNT)

Dimension: Category

[Or]

You should probably read up a guide on set analysis in general to get a better idea of how to do this sort of thing...

sum({<date_key={"$(=max(date_key))"} , Category -= {'Sport','Test'} >}NEW_SUBSCRIPTION_COUNT)

You can include multiple fields in set analysis, separated by a comma.

[Michael_Tarallo]

Hi Nazanin - in addition to these answers that speak of Set Analysis - you may want to take a look at this video:

Introduction to Set Analysis (video) - Part 1

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Michael Tarallo

Qlik