Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team ,
I have a pivot table in Qlikview where i have around 45+ fields and all are dimensions only.
Pivot table is used to merge the Dimensions data rather than displaying row by row .
In Expression i am using
only({<CheckinDate={">=$(vstartdate)<=$(venddate)"}>}chr(32))
i have used chr(32) to show blank space as in pivot at the end of the chart as we cant hide fields just like in "Staright Table " right ..
now the issue is when i am adding more fields to the Pivot Table ,i am getting blank cells in Accesspoint but when exported ,data is getting populated in that cells.
Not sure of what the issue is .
Attached the Snapshot of the issue .
Could some one help me on this .
Thanks,
Anjee
Could some one help on this ?