topic Re: New clients in QlikView

New clients

petermoyaert — Mon, 12 Oct 2015 10:09:12 GMT

We have a field available with date of creation of new client, called "Since_Client".

I want to see sales of clients that became client in the period since today minus 180days. I have a variable that is called "vMaxDate" but when I start to deduct 180 days it fails.

Re: New clients

sujeetsingh — Mon, 12 Oct 2015 10:11:35 GMT

Peter,

try using $(variable) Hence you can calculate the difference as

Interval(vMaxDate-Since_Client,'dd')

Re: New clients

swuehl — Mon, 12 Oct 2015 10:12:37 GMT

Create a chart with dimension Customer and as expression something like

=Sum({<Since_Client = {">=$(=Date(Today()-180))"}>} Sales)

You need to check that format of Since_Client and the set modifier created using dollar sign expansion is matching.

Re: New clients

preminqlik — Mon, 12 Oct 2015 10:16:20 GMT

just replace today() with your vMaxDate in Swuehl exp and also by pass any other calendar Category like below

=Sum({<Since_Client = {">=$(=Date(num(vMaxDate)-180))"},Year=,Month=,Day=>} Sales)

Re: New clients

petermoyaert — Mon, 12 Oct 2015 13:46:34 GMT

Thank you all for the feedback. It works.

Re: New clients

avinashelite — Mon, 12 Oct 2015 13:57:35 GMT

Hi Peter,

If you have got the answer , mark the correct answer and close this thread so that it will others too