topic Selection in three date fields in QlikView

Selection in three date fields

Thu, 07 May 2015 18:17:46 GMT

Hi All,

I am facing a problem wherein i have three date fields namely

1. Sales Posting Date

2. Feedback1

3. Feedback2

Now, when i select for eg. 01/04/2014 to 31/03/2015 in Sales Posting Date then i need the same date range to be used for the other two date fields as well, though other values may be possible for that particular selection.

I need to use this as an expression in a text box. Kindly help me on the same.

Re: Selection in three date fields

ramoncova06 — Thu, 07 May 2015 19:32:48 GMT

are you using a master calendar ?

The Master Calendar

I believe in your case you might be able to use a canonical date also

Canonical Date

Re: Selection in three date fields

petter — Thu, 07 May 2015 19:36:22 GMT

Where are these date fields placed? In three different tables? Or are they all in the same table?

Re: Selection in three date fields

petter — Thu, 07 May 2015 20:04:08 GMT

If you have all three dates in one table like for instance a Sales table - here is a small demo to show how you could approach your date selection (I have attached the demo App too):

Re: Selection in three date fields

Fri, 08 May 2015 02:33:12 GMT

Hi...

All these dates are in three different tables.

When we select a date range in Sales table, the corresponding values get highlighted in other tables but what i need is, the data in the other two tables containing feedback dates should be shown for the same date range that is selected. This i want to do in the front end.

Re: Selection in three date fields

petter — Fri, 08 May 2015 04:56:26 GMT

So what are the key fields connecting the tables? Could you give us the details about the various tables involved?