Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Chart not showing correctly on filter selection ?

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.

showing.PNG

notshowing.PNG

7 Replies
gowtham_patnaik
Contributor III
Contributor III

I think issue is with adding cost price as dimension.

try to add it as an expression.

adamdavi3s
Master
Master

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
Specialist
Specialist

Plss check:

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

Hopeit helps.

Sachin.

sdmech81
Specialist
Specialist

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

There r syntheteic keys n all.plss cross verify

Sachin

sdmech81
Specialist
Specialist

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
Master
Master

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
Specialist
Specialist

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