Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlikers,
I am having a scenario which is like this...
I am having a TransactionDate Field which is used as a MasterCalender and created one more field say TestDate which stores TransactionDate+1 logic...
Now If I selects multiple date from TransactionDate fields say, 04/Dec/2015, 06/Dec/2015, 10/Dec/2015
TestDate would return: 05/Dec/2015, 07/Dec/2015, 11/Dec/2015
Now I want to compare these TestDate with TransactionDate and want to fetch only matching data...
Here User can selects N values...So what I did, I used Concat(TestDate,'|') which is storing all selected date only..
How can I compare these Concatenated Date with TransactionDate in Set Analysis???
I thought of SubField(), Min(),Max() etc but they can fetch only one value at one time.
Can I use somthing like Looping at Set Analysis which will fetch ConcatenatedDate one by one & will be comparing those returned values with TransactionDate??
Any Range Function which can solve this issue?
Guys,
Please suggest..
Any help appreciated
I'm not sure if I have understood your logic but you could try something like this:
sum({< TransactionDate = {"$(=chr(39) & concat(distinct date(TransactionDate+1, 'DD/MMM/YYYY'), chr(39) & ',' & chr(39)) & chr(39))"}>} Value)
- Marcus
Now I want to compare these TestDate with TransactionDate and want to fetch only matching data...
Can you explain that? If TestDate is always TransactionDate+1 these dates can never match.
I'm not sure if I have understood your logic but you could try something like this:
sum({< TransactionDate = {"$(=chr(39) & concat(distinct date(TransactionDate+1, 'DD/MMM/YYYY'), chr(39) & ',' & chr(39)) & chr(39))"}>} Value)
- Marcus
I mean to say, If a User selects any TransactionDate, I should get the result of TransactionDate+1 values..It could be N values.
Am I clear?
Hi,
Not sure, but indirect set analysis will help you
just try
sum({<TransactionDate=p(TestDate)>}Value)
Regards
If Marcus's provided solution doesn't work, I would try this without double quotes:
Sum({< TransactionDate = {$(=chr(39) & Concat(DISTINCT Date(TransactionDate+1, 'DD/MMM/YYYY'), chr(39) & ',' & chr(39)) & chr(39))}>} Value)