Discussion Board for collaboration related to QlikView App Development.
Hi All ,
The chart report is not showing the cost price when fiscal month is jul,aug ,sep but only shows the cost price when fiscal month is dec and no selection on fiscal month.
sample model attached.
I think you need to review your data model.
It's hard to tell what is going on as you have a synthetic key in there and we obviously don't have any access to source data to be able to reload this for you.
I think there should be association based on product Key.
There it combinationof product key and Period Key..Check out your granular details.
If u have any doubt just give columns and tables example here so that ppl can comment.
I disagree, I suspect that product and date is correct as the price could be different at different points in time.
This thread goes into some excellent detail on how to make sure you have valid data for all time points
Hi Thts wt its uncertain.Nether u can or I cannot say until we look into the data and tables and their granularities.
That's what I said with uncertainity and asked him to give more picture abt it.