topic Re: Need Help : How can I make change my "input zone" with Date(Today() - X) in QlikView

Need Help : How can I make change my "input zone" with Date(Today() - X)

Thu, 29 Nov 2012 11:36:26 GMT

Hi,

How can visualize my table with StartDate = Date(Today() - X)

X is a variable that can change.

For example : Date(Today() -3), I can see all records of 26/11/2012.

Thanks for your help.

Judi.

Re: Need Help : How can I make change my "input zone" with Date(Today() - X)

vgutkovsky — Thu, 29 Nov 2012 13:39:54 GMT

Judi,

See attached. You can also modify the set analysis to select >= if that's your business rule.

Regards,

Vlad

Re: Need Help : How can I make change my "input zone" with Date(Today() - X)

swuehl — Thu, 29 Nov 2012 13:42:35 GMT

Just create an input box with a numeric range and assign the selected value to a variable X or vVar.

Then, you'll need a straight table, a simple table box doesn't allow to use calculated dimensions / expressions.

In a straight table (or any other chart except the table box), create a calculated dimensions:

=if([Start Date]>=today()-vVar,[Start Date])

Maybe add your other dimensions, and maybe as expression add a =sum(Sales).

That's all (see attached).

Instead of the calculated dimension, you can use a set expression or condition with all your expressions (there are plenty of demos in the forum on how to do this).

Regards,

Stefan

Re: Need Help : How can I make change my "input zone" with Date(Today() - X)

Thu, 29 Nov 2012 17:09:49 GMT

Thank for your help.

Could you please verify my expression, I have some difference.

When I select 19/06/2012 on my listbox, I visualize 6 records on

19/06/2012.

When I use my input zone with X=163. The date is 19/06/2012, reocords 6

lines in result but my list shows others date different of 19/06/2012.

Thanks,

Re: Need Help : How can I make change my "input zone" with Date(Today() - X)

Sat, 01 Dec 2012 10:33:18 GMT

Thanks a lot.

It works !!

I was some trouble into my model.

Judi.