Date Comparison between current and history data

[#1]

I am taking history data and current data into my qvd for the date fields. I have stored  both the dates with the help of an identifier as 'current date' (the day on which the report is run) and  'history dates'(previous dates which excludes the report run date using qvds).

I want to select 2 dates

1. from current date

2. history date

so that i can make a comparison between the data which had been obtained between these 2 dates.

But I am not able to select the history date and the  current date at the same time.

Does Qlikview doesn't enable this option or is there a work around for this?

Update : If I haven't made my explanation clear, I have attached a qvw  of the same.

I want to do selections in both Currrent_date and History_Date

Message was edited by: Sonia Prakasam

[#2]

use 2 expressions.

sum({<Identifier={'current date'}>} value)

sum({<Identifier={'history date'}>}value)

If you want a thorough and a comprehensive implementation of displaying current and historical figures side by side for each dimensional value, you'll have to investigate about the 'AsOf' tables.

[its_anandrjs]

Hi,

You can use calender objects for this and make selections in the front end and select date according to current and history and your data get filtered and in any straight table or table box you can see the data or compare it.

Hope this helps

Thanks & Regards

[#4]

PFA.

[#5]

Hi,

You can't select those 2 dates at a same time

Load those dates as 2 seperate columns and provide those for selections seperately and you can catch those 2 selections either directly/using variables and u can achieve your task.

[#6]

Hi Ramkumar,

I don't think I made myself clear while explaining what I wanted. I have posted an attachment of the same.

If you went through that and provide me a suitable answer, I would be grateful.

[#7]

Hi Anand,

I tried using the calendar object, still I am not able to get the desired result.

[#8]

Hi Ravi,

I had my dates split into 2 as current date and history date. But I was not able to get what I was looking for.

[#9]

See this..