Having data available from 01/01/2016 to 8/30/2017 , in this for some sites containing all dates, but some not
usually in the pivot all dates are coming , until if we select any site (Dates are missing which are not associate or no data )
can we get all dates even after selection happen on site ?
also i enable show all values and disable suppress zero values as well
Please help on this ?
If you display your detail in a line/bar chart rather than a pivot, you can enable "Continuous" mode on the axis in question, which will automatically fill in any steps in your dimension between the min and max. I don't believe QlikView's default behaviour will allow you to show disassociated values in pivot tables.
Sorry to be the bearer of bad news.