Chart not showing correctly on filter selection ?

[suvechha_b]

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.

[gowtham_patnaik]

I think issue is with adding cost price as dimension.

try to add it as an expression.

[adamdavi3s]

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.

[sdmech81]

Plss check:

Your cost_price_date is not having dates fr those fr which its not showing.

Hopeit helps.

Sachin.

[sdmech81]

Yes,Even I also agree..ur data model is not looking fine.

There r syntheteic keys n all.plss cross verify

Sachin

[sdmech81]

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.

Sachin

[adamdavi3s]

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

Generating Missing Data In QlikView

[sdmech81]

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.

Sachin