Discussion Board for collaboration related to QlikView App Development.
I have a straight table with the following two dimensions and four 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?
look at dimension limits tab of chart properties..
or share a sample qvw...
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.