topic Chart not showing correctly on filter selection ? in QlikView

Chart not showing correctly on filter selection ?

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Chart not showing correctly on filter selection ?

gowtham_patnaik — Tue, 14 Feb 2017 09:04:39 GMT

I think issue is with adding cost price as dimension.

try to add it as an expression.

Re: Chart not showing correctly on filter selection ?

adamdavi3s — Tue, 14 Feb 2017 09:05:50 GMT

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.

Re: Chart not showing correctly on filter selection ?

sdmech81 — Tue, 14 Feb 2017 09:33:24 GMT

Plss check:

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

Hopeit helps.

Sachin.

Re: Chart not showing correctly on filter selection ?

sdmech81 — Tue, 14 Feb 2017 09:34:24 GMT

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

There r syntheteic keys n all.plss cross verify

Sachin

Re: Chart not showing correctly on filter selection ?

sdmech81 — Tue, 14 Feb 2017 09:53:38 GMT

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

Re: Chart not showing correctly on filter selection ?

adamdavi3s — Tue, 14 Feb 2017 09:57:25 GMT

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

Re: Chart not showing correctly on filter selection ?

sdmech81 — Tue, 14 Feb 2017 10:13:00 GMT

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