topic Re: Multiple Values, One dimension in QlikView

Multiple Values, One dimension

evansabres — Thu, 30 Aug 2018 18:36:01 GMT

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

Re: Multiple Values, One dimension

neelamsaroha157 — Thu, 30 Aug 2018 18:37:12 GMT

Can you share a sample file?

Re: Multiple Values, One dimension

evansabres — Thu, 30 Aug 2018 18:39:32 GMT

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

Re: Multiple Values, One dimension

evansabres — Thu, 30 Aug 2018 18:45:29 GMT

There would be multiple dates for each of the dimensions

Re: Multiple Values, One dimension

vamsee — Thu, 30 Aug 2018 18:47:30 GMT

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?

Re: Multiple Values, One dimension

evansabres — Thu, 30 Aug 2018 18:50:32 GMT

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

Re: Multiple Values, One dimension

evansabres — Thu, 30 Aug 2018 18:52:40 GMT

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

Re: Multiple Values, One dimension

evansabres — Thu, 30 Aug 2018 18:55:05 GMT

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

Re: Multiple Values, One dimension

vamsee — Thu, 30 Aug 2018 19:01:32 GMT

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