
Re: Hide lines based on formula
Sergey Pokasov Jun 26, 2015 5:53 AM (in response to Günter Angerer)Hi!
if([Ready for dispatch(kg)]>0,put_here_your_expressions_for_each_column).
For example, I have 3 expressions:
sum(sales),
count(id),
max(days) < this I want to use for check zero
then
if(max(days)>0,sum(sales))
if(max(days)>0,count(id))
max(days)

Re: Hide lines based on formula
Günter Angerer Jun 26, 2015 6:09 AM (in response to Sergey Pokasov)Hello Sergey,
this seems to be the right approach. I have my formulas based on your proposal which brings me to the correct table, but the totals are wrong...
This is again an Excel screenshot to show the difference. The first line shows the totals calculated by Excel (which are correct for the values shown) and the last line the total that comes from QlikView. Obviously the totals are not effected by the formula. How can this be changed?
Thanks,
Günter



Re: Hide lines based on formula
Jebamalai Dass Jun 26, 2015 5:53 AM (in response to Günter Angerer)please send us the expression you use

Re: Hide lines based on formula
Navdeep Kumar Jun 26, 2015 6:06 AM (in response to Günter Angerer)You can try in all expression,
if(sum(Produced)<>sum(Delivered),.......required expression, null()).... PFA

Test.qvw 150.0 K


Re: Hide lines based on formula
Narendra Reddy Jun 26, 2015 6:10 AM (in response to Günter Angerer)Hi
U can write like this (if u r trying to show them in straight table in qlik)
if(([produced(kg)][delivered])>0,([produced(kg)][delivered]))
dont put anything in else part ...and give ok
make sure that u shd have write these two exp (produced,delivered) before this exp..

Re: Hide lines based on formula
Dhiraj Kumar Jun 26, 2015 6:16 AM (in response to Günter Angerer)Hi Gunter ,
In Second your expected table in Dispatch qty column's expression you should write below code
if(sum(ProducedQty) <> sum(DeliveredQty) ,sum(Produced)sum(Delivered) ).
Hope this would be helpful.