Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Variable value change according to dimension in set analysis

Hi,

I have Date, Membership signup date ,Customers and orders, I want the output where each customer before signup how many orders or after signup how much orders they are placed.

Each customer have their each signupdate.

For example-

   

CustDateSignUp dateorders
12017-12-302017-10-300.49145
12017-12-122017-10-300.98633
12017-11-192017-10-300.32968
12017-11-162017-10-300.24649
12017-11-062017-10-300.19674
12017-11-062017-10-300.19695
12017-11-062017-10-300.19768
12017-11-062017-10-300.19798
12017-10-302017-10-300.33333
12017-10-072017-10-300.5
12017-03-252017-10-301
12017-02-232017-10-300




I want output sum(orders) before signup date  2017-10-30 and after signupdate, I have so many customers and having different signup date.


Thanks for help!

14 Replies
pradosh_thakur
Master II
Master II

Thanks for the explanation !! As i said before learning new things everyday.

Learning never stops.
Anonymous
Not applicable
Author

Hi,

This is the only problem I am facing,  It takes min and max date of all customers and evaluate. But every customer have their own signupdate

Please help me on this.

Thanks

pradosh_thakur
Master II
Master II

Hi Paridhi

As Sunny explained Set analysis is evaluated once per the chart so you have to turn to other thing for example here scripting if you want row wise implementation  like this .

Please change the script. it will definitely work for you.

regards

Pradosh

Learning never stops.
Anonymous
Not applicable
Author

Hi,

What I need to change in my script?

Thanks in advance

sunny_talwar

I showed you what can be changed... don't like any of the ideas?