topic Re: Drill Down Line Chart in QlikView

Drill Down Line Chart

sqlpuzzle — Fri, 15 Nov 2024 23:34:42 GMT

Hi ,

Doing a simple line chart.

The x-axis dimension should be Year -> Month-Year -> Date-Month-Year in a drilldown or a cyclical.

The measure should be the count of a filed with respect to the above dimension.

How can this be done?

A sample is attached.

Re: Drill Down Line Chart

QFabian — Mon, 23 Nov 2020 22:07:34 GMT

Hi @sqlpuzzle , try doing this in your script :

[Data]:
LOAD Id,
Date(floor(date),'DD MMM YYYY') as date_month_year,
monthname(date) as month_year,
year(date) as year
FROM
data.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);