Multiple Values, One dimension

[evansabres]

I have a dimension called 'Came From Code' and another dimension 'DTE' and a field called 'Orders'. Each Came From Code can have orders on different dates

I want to have a chart that shows the Quantity of 'Orders' for each 'Came From Code' over time (DTE)

I created the chart, with DTE as the dimension, orders as the expression and then have a drop-down for the came for codes

When I select a came from code, the chart does not show all of the dates on which there are orders.

Where am I going wrong

[neelamsaroha157]

Can you share a sample file?

[evansabres]

Came From Code	Date	Click-Throughs	EDP Visits	Orders	Tickets	Avg Conv	Total Value
CFC_AM_PHP	5/14/2018	4	1	0	0	0.00%	$0.00
CFC_BILLS_BBA	11/16/2017	38	0	0	0	0.00%	$0.00

[evansabres]

There would be multiple dates for each of the dimensions

[vamsee]

What kind of chart are you trying to create or you have an issue with? Is it bar?

Your data looks okay.

Can you share your QVW with some sample data?

[evansabres]

Cannot share the app at this time. Basically, for each came from code, there can be up to 365 dates. The idea of the chart is to first, make a selection from the drop-down to then see just that particular came from code over the dates

[evansabres]

Many dates may have no value, which I think is causing only some of the dates to display?

[evansabres · Accepted solution]

Just needed to:

IN DIMENSION TAB-

SELECT FIELD AND THEN CHECK ON SHOW ALL VALUES

IN PRESENTATION TAB-

SELECT FIELD AND THEN UNCHECK ON SUPRESS NULL VALUES

Dumb mistake

[vamsee]

Yeah if have 0 or null values the charts by default suppress them.

Also, as a suggestion create a master calendar to populate missing dates.

Generating Missing Data In QlikView