topic Re: date function in QlikView

date function

maniram23 — Mon, 24 Aug 2015 18:09:41 GMT

Hi experts,

I have one date field in my data.and some id,sales of data is there.

here if I select any date it has to go 7 days back.

here the data in date field is 01/01/2015 to 20/01/2015 for example

if I select 07/01/2015 it has to show 01/01/2015 and 07/01/2015 of both dates data.

same way if I select 01/01/2015 it has to show 25/12/2014 and 01/01/2015 of both dates data.

I have some ideas but those ideas are not giving proper result.

any ideas.

Re: date function

kaushiknsolanki — Mon, 24 Aug 2015 18:13:28 GMT

Hi,

You can use two expression and add them, just like below.

Sum({<Date = {"$(=Max(Date))"}>}Sales)

Sum({<Date = {"$(=Max(Date)-6)"}>}Sales)

Regards,

Kaushik Solanki

Re: date function

Mon, 24 Aug 2015 18:14:26 GMT

Could you post a sample document?

ans just simply try debugging date +7 to see if you are getting the correct date?

Re: date function

swuehl — Mon, 24 Aug 2015 18:16:46 GMT

You can use set analysis for this.

For example, create a straight table chart with dimension id and then two expressions:

=sum(sales)

=sum({<datefield = {"$(=Date(max(datefield)-6,'DD/MM/YYYY'))"}>} sales)

replace id, datefield and sales with your appropriate field names. You may need to adjust the Date() format code to match your format of datefield.

Re: date function

Kushal_Chawda — Mon, 24 Aug 2015 18:18:39 GMT

wan to show only for both dates or for all 7 days back. If it is for only both dates then you can go for what kaushik has suggested. If you want for all 7 Days then use below

Sum({<Date = {">=$(=Max(Date)-6)<=$(=Max(Date))"}>}Sales)