Announcements
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
cancel
Showing results for
Did you mean:
Creator

Filter the values based on condition

Hi Team,

In Straight Table, I want to show only Profit% column has < 25% value only. (Customer C and D wants to display)

how it is possible

Labels (4)

• Variables

7 Replies
Master

Suppose you have Profit% = (Profit/Cost Price)*100.

Use the below as the calculated dimension and uncheck the option to show null values.

=Aggr(If(Sum(Profit/Cost Price)*100 < 0.25,[Customer Name]),[Customer Name)

Creator
Author

We have a formula to derive the Profit % (E.g (365/Column(5)) * Column(6))

So, I want Profit% column has < 25% value only. (Customer C and D wants to display)

using Expression we can achieve this??

Master

Maybe with the use of If() as below.

If(((365/Column(5)) * Column(6)) < 0.25,(365/Column(5)) * Column(6)))

Creator
Author

In Table box, It shows all 4 Customers.

For Customer A and B the Profit% Column indicates NULL value.

But I Need to remove A and B customer from Table Box

Master

What is your expected result? maybe share a snippet.

Creator
Author

Source Data

I Need Output Like this

Master

Use this as a calculated dimension thus enabling the option to suppress the null values. Replace the column names with the actual expressions

=Aggr(If((365/Column(5)) * Column(6))< 0.25,[Customer Name]),[Customer Name)

Tags
Community Browser