Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to only show certain data in a straight table

Hey,

I have a straight table with the following two dimensions and four expressions.


Dimensions:

CustomerNumber
CustomerName


Expressions:

Turnover =sum(Amount_Turnover)
Cost =Sum(Amount_Royalty)+Sum(Amount_Sales)
EBT =Sum(Amount_Turnover)-(Sum(Amount_Royalty)+Sum(Amount_Sales)
EBT degree (In percent)
=(Sum(Amount_Turnover)-(Sum(Amount_Royalty)+Sum(Amount_Sales)))/(Sum(Amount_Turnover)


I need my table to show only the customers which Amount_Turnover is more than zero and which EBT degree is 25% or less.

I need to do it without editing the script, so is it somehow possible to do this using the Chart Properties?

Kind regards,

Peter


2 Replies
Highlighted
Specialist II
Specialist II

Re: Hot to only show certain data in a straight table

yes possible...

look at dimension limits tab of chart properties..

or share a sample qvw...

Highlighted
Contributor
Contributor

Re: How to only show certain data in a straight table

Hi,

Add the following in your dimensions:

IF(Amount_Turnover>0 and EBT degree<=25,Dimension1,null()) and suppress the value when it is null.

Limit this to your first Dimension.