topic Re: Problem with date field in QlikView

Problem with date field

Tue, 14 Feb 2017 05:43:57 GMT

Dear all,

I am very new to qlikview and I have a problem with regards to a date field which contains information like:

(F11, F12, 2015 P01, ... 2015 P12, 2016 P01, ... , 2016 P12, 2015 Q1, 2015 Q2) and the list goes on,

What would be the best way to visualize this data if I want to create a bar chart with the dates running on the x axis. The Y axis would then represent the cash revenue.

I would also like to have the data in the x axis segmented into quarters and months in the form of (p01-p12), and a total cash revenue summed up over the year 2015.

Attached below is a sketch as to what I would like to be represented in my bar chart. Forgive the really ugly and primitive drawing.

Thanks so much for your input and assistance, thanks in advance.

Kind regards,

Royce Tang

Re: Problem with date field

sunny_talwar — Tue, 14 Feb 2017 10:35:51 GMT

It might help us help you better if you can provide some real data and provide the expected output. Would you be able to provide a sample?

Re: Problem with date field

Tue, 14 Feb 2017 16:26:27 GMT

Cheers for the reply Sunny ! I am not sure how to link the files over but I can try to type it out here

sales_type Customer Date Cash

b2b xy 2015P01 200

b2b xy 2015P02 220

b2b xyh 2015P02 300

b2b xyah 2015P02 200

b2c xyh 2015P03 206

b2c xf 2015P04 900

b2c xy 2015P05 206

b2d xyr 2016P01 200

b2a xyd 2016P02 200

b2b xy 2016PPP03 400

b2b xy F1 400

b2b xy F8 1400

my expected output is to have a bar graph with

Re: Problem with date field

sunny_talwar — Wed, 15 Feb 2017 10:14:10 GMT

So in addition to sales for individual sales for each period, you want to highlight the total sales for each year? Is that what you are looking for?

Re: Problem with date field

Wed, 15 Feb 2017 10:21:39 GMT

thats exactly what I am looking for ! I have tried to solve this problem and have got to a point as of such as seen in the link

Duplicate values in bar Chart

Re: Problem with date field

sunny_talwar — Wed, 15 Feb 2017 10:41:49 GMT

These are two overlapping charts and that's the best I am able to do.... see if this works for you