topic Re: Re: Date Comparison between current and history data in QlikView

Date Comparison between current and history data

Wed, 26 Mar 2014 05:19:55 GMT

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

Re: Date Comparison between current and history data

Wed, 26 Mar 2014 05:25:44 GMT

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.

Re: Date Comparison between current and history data

its_anandrjs — Wed, 26 Mar 2014 05:26:01 GMT

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

Re: Re: Date Comparison between current and history data

Wed, 26 Mar 2014 05:33:01 GMT

PFA.

Re: Date Comparison between current and history data

Wed, 26 Mar 2014 05:37:20 GMT

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.

Re: Date Comparison between current and history data

Wed, 26 Mar 2014 06:58:25 GMT

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.

Re: Date Comparison between current and history data

Wed, 26 Mar 2014 06:59:02 GMT

Hi Anand,

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

Re: Date Comparison between current and history data

Wed, 26 Mar 2014 07:00:44 GMT

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.

Re: Re: Date Comparison between current and history data

Wed, 26 Mar 2014 09:45:08 GMT

See this..