Pick value

Tue, 11 Feb 2014 14:45:32 GMT

Hello gurus!

I am pretty new to qlikview and I would be happy if you give me a hand about issue which I explain it below:

MY DATA SET:

[Customer]

Date_ID: YYYYMMDD (Sting data)

Count: Number

[Order]

Date_ID: YYYYMMDDhh:mm

Count: Number

[Amount]

Date_ID: YYYYMMDD

Sum: Number

I need to compare those tables in a line chart and I want to analyze for each table as well...

My first question: How can I compare those tables if the date format is string and order date is different than others..(time based)

Second question: How to pick a specific date on chart? I want to only do it on that chart otherwise I do give condition to whole report.

Last question: I would like to create a chart that shows order date by based daily and other chart should only show based on hour..

If you share your time and help me out I would be appreciated in you..

Regards..

I have attached sample data set and if you give me a feedback with a sample qvd report I would be happy..

Re: Pick value

Nicole-Smith — Tue, 11 Feb 2014 15:50:42 GMT

1. You should have the DATE_ID key between your tables formatted the same. Here is load script that will do so:

Order:

LOAD timestamp#(ORDERDATE_ID, 'MMDDYYYYhh:mm') as ORDERDATE_ID,

    date(floor(timestamp#(ORDERDATE_ID, 'MMDDYYYYhh:mm')),'MMDDYYYY') as DATE_ID,

    COUNT

FROM Data.xlsx

(ooxml, embedded labels, table is ORDER);

Customer:

LOAD date#(DATE_ID,'MMDDYYYY') as DATE_ID,

    CNT_CUSTOMER

FROM Data.xlsx

(ooxml, embedded labels, table is CUSTOMER);

Profit:

LOAD date#(DATE_ID,'MMDDYYYY') as DATE_ID,

    AMOUNT

FROM Data.xlsx

(ooxml, embedded labels, table is PROFIT);

Once you set your data up like this, you can use DATE_ID as a dimension in a line chart, which will then allow you to compare all 3 tables (see the top line chart in my example file that is attached).

2. To only pick a date on a chart and to have it not affect anything else on the report, give the chart a different alternate state (you can create alternate states in Settings > Document Properties > General > Alternate States (button), then add the alternate state to the chart in Chart Properties > General > Alternate State (dropdown), see the top line chart in my example file that is attached).

3. This is where you use the original ORDERDATE_ID field which is no longer a key between the tables for the date time, and the DATE_ID for just the date (see the bottom two line charts in my example file that is attached).

topic Re: Pick value in QlikView

Pick value

Re: Pick value