topic Re: Re: Expression Problem in QlikView

Expression Problem

vipin_mishra479 — Wed, 25 Jun 2014 14:53:25 GMT

Hi all ,

Hope you all well,

Actually what i have facing one problem which i post here please reply ASAP.

My requirement is

I have weekday and date field and i want to show just example today is Wednesday and date is 25-6-2014 there is some value

and i want to show Wednesday of last year 26-06-2013 value i am confuse how i calculate . i have do something my application

here i get the date in dimension this year and last year of same day.

but i not able to find last year same day data.

I attached the qvw file please help

jaimeaguilar — Wed, 25 Jun 2014 15:17:59 GMT

Hi, maybe you can use addyears function to get the same date but for past year, like this:

= WeekDay(addyears(Today(),-1)) & ' ' & Date(addyears(Today(),-1))

so taking the example with today's date you'll get this after evaluating the expression:

Today is Wed 6/25/2014

and the same date but for past year:

Tue 6/25/2013

vipin_mishra479 — Wed, 25 Jun 2014 16:25:23 GMT

Hi Jaime,

Thanks for the reply,

i get the date in dimension but i could not find the value in expression for last year week day

jaimeaguilar — Wed, 25 Jun 2014 16:53:31 GMT

Maybe like this, check the attached example please

vipin_mishra479 — Wed, 25 Jun 2014 17:18:59 GMT

hi jaime,

no is not working

in chart how u get both date value.

jaimeaguilar — Wed, 25 Jun 2014 17:29:47 GMT

what chart you want to use?

vipin_mishra479 — Wed, 25 Jun 2014 17:37:27 GMT

previously i attached the qvw file here i use on pivot table and in this table i create a date of current year and last year

and i create two expression . here i want in my first expression want first date value and second expression second date value....

jaimeaguilar — Wed, 25 Jun 2014 17:48:26 GMT

Like this:

I changed the pivot table, so you can see week day for CY and PY as well as exact date,