Discussion Board for collaboration related to Creating Analytics for QlikView.
Hi im doing month on month difference for selected year i have used before function but its creates one xtra cols wiht 0 value can anyone guide me how i can hide that.
Have attached application
Thanks in advance.
please find the modified app.
Thanks for try.still it shows jan col i need hide that cols if all cols value are zero
hiii try this in expression tab of pivot table and
cheked on conditional and in that write this expression
null1 is my field name
hope it helps
see the atached image
Thanks.Its not working sir, i have attached my sample app in this thread.i need to hide cols if all value is 0. eg Jan cols