# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
cancel
Showing results for
Did you mean:
Contributor III

## i want show amount >10 and only show domain "a" in straight table

i have this table

i need show  like this table

i

1 Solution

Accepted Solutions
Partner - Contributor III

Hello Vijay,

1) Take a table chart

2) Add first dimension as below.

=if(domain='a' and amount>10,domain)

Label it as Domain and uncheck include null values.

=amount

I hope this helps.

7 Replies
Specialist II

This can be your amount measure:

sum({<amount = {">10"}, domain= {'a'} >} amount)

Specialist II

Create New dimension like

=if(Amount>10,domain) as NewDimension use this in table and uncheck include null values.

Regards,
Abhijit
keep Qliking...
Contributor III
Author

i getting this

i need like this

Specialist II

You're right, what i said was incorrect if you don't have any other dimension to break these values out into rows.

Can use dimensions:

=aggr(only({<domain= {'a'} >} domain), domain)

=aggr(only({<Amount= {">10"} >} Amount), Amount)

Specialist

Just display the amount as a dimension, rather than a measure

Partner - Contributor III

Hello Vijay,

1) Take a table chart

2) Add first dimension as below.

=if(domain='a' and amount>10,domain)

Label it as Domain and uncheck include null values.