Qlik Community

New to Qlik Sense

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

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Vijayqlik4171
Contributor III
Contributor III

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

i have this table 

Vijayqlik4171_0-1632838413739.png

i need show  like this table

Vijayqlik4171_1-1632838484090.png

 

i

1 Solution

Accepted Solutions
akshatagrawal
Partner - Contributor III
Partner - Contributor III

Hello Vijay,

Please use below solution.

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.

3) Add second dimension.

=amount

I hope this helps.

 

View solution in original post

7 Replies
stevejoyce
Specialist II
Specialist II

This can be your amount measure:

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

abhijitnalekar
Specialist II
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...
Vijayqlik4171
Contributor III
Contributor III
Author

i getting this

Vijayqlik4171_0-1632839998546.png

 

 

i need like this

Vijayqlik4171_1-1632840020122.png

 

stevejoyce
Specialist II
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)

juleshartley
Specialist
Specialist

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

akshatagrawal
Partner - Contributor III
Partner - Contributor III

Hello Vijay,

Please use below solution.

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.

3) Add second dimension.

=amount

I hope this helps.

 

Vijayqlik4171
Contributor III
Contributor III
Author

thank you