Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Valued Contributor

Multiple Values, One dimension

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

1 Solution

Accepted Solutions
Highlighted
Valued Contributor

Re: Multiple Values, One dimension

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

View solution in original post

8 Replies
Highlighted
Valued Contributor II

Re: Multiple Values, One dimension

Can you share a sample file?

Highlighted
Valued Contributor

Re: Multiple Values, One dimension

Came From CodeDateClick-ThroughsEDP VisitsOrdersTicketsAvg ConvTotal Value
CFC_AM_PHP5/14/201841000.00%$0.00
CFC_BILLS_BBA11/16/2017380000.00%$0.00
Highlighted
Valued Contributor

Re: Multiple Values, One dimension

There would be multiple dates for each of the dimensions

Highlighted
Valued Contributor

Re: Multiple Values, One dimension

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?

Highlighted
Valued Contributor

Re: Multiple Values, One dimension

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

Highlighted
Valued Contributor

Re: Multiple Values, One dimension

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

Highlighted
Valued Contributor

Re: Multiple Values, One dimension

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

View solution in original post

Highlighted
Valued Contributor

Re: Multiple Values, One dimension

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