Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to display particular ledger account on filtered result by dimension

Hi, I want to display the particular account numbers detail from the Dimension result.

Example

I have Ledger account starts from 100000 to 999999, but I need to display the Salary Expenses which is starting from 60000....699999. Please let me know how to define the expression to list the particular account.

Thanks & Best Regards

1 Solution

Accepted Solutions
Anil_Babu_Samineni

May be this?

If([Ledger account] >= 60000 and [Ledger account] <= 699999, [Ledger account])

Irrespective of Global filter.

To this? You can manipulate your measure like

Sum({<Global=>} Measure)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Irrespective of Global filter.

Anil_Babu_Samineni

May be this?

If([Ledger account] >= 60000 and [Ledger account] <= 699999, [Ledger account])

Irrespective of Global filter.

To this? You can manipulate your measure like

Sum({<Global=>} Measure)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful