Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

compare date this year with date last year

hi,

I'm trying to to compare two dates. for example 2012-08-01 with the thursday last year it was 2012-08-03. But in the pivottable the two dates are not shown next to each other how can I solve this problem?

regards,

MT

7 Replies
Not applicable
Author

what is the dimension?

better post a sample qvw file here

Not applicable
Author

my dimension is the day(date)

Not applicable
Author

you need to post a sample becouse there are many ways to do that depending on the sheet objects, data structure, selection etc

could you?

Not applicable
Author

I cant post an sample sorry

Not applicable
Author

i'm sure you can preper a small example with one chart and random data (using inline script)

i just want to know where you want to compare those two values - so i need to know how does your chart look like

Not applicable
Author

ok what I want now is that my chart looks like that

31      Mi      01.08.2012     03.08.2011     profit2012     profit2011

is that possible??

one way of thinking was to use date insteat of a dimension as an expression

Not applicable
Author

sorry for late answer;)

try to use only day and week  as a dimension and use set analysis in teh expression (plus add calendar table)

see attached file