-
Re: help set analysis
Digvijay Singh Feb 9, 2018 10:35 AM (in response to EZEQUIEL CONTE)What dimension you are using in bar/table chart?
-
Re: help set analysis
EZEQUIEL CONTE Feb 9, 2018 10:46 AM (in response to Digvijay Singh )Sorry, as a dimension I'm using the period_name field in table "3" (which I did not add in the previous question).
/ * Table 3
period_1, period_name
201507, Jul-2015
201508, Aug-2015
201510, Oct-2015
201702, Feb-2017
* /
Table 3:
load
period_1, // pk
period_name
from z (qvd);
Thank you very much!-
Re: help set analysis
Digvijay Singh Feb 9, 2018 11:00 AM (in response to EZEQUIEL CONTE)I don't think even Table 3 would help much, somehow you need to associate Table 1 and 2 through date, not company. Because your matching dates are having different companies. Since company is associating your two tables data, it won't allow the match.
See the sample attached, may be it can help you to make required changes.
-
Re: help set analysis
Digvijay Singh Feb 9, 2018 11:01 AM (in response to Digvijay Singh )Sample attached
-
test12.qvf 208.0 K
-
-
-
-
Re: help set analysis
Digvijay Singh Feb 9, 2018 10:48 AM (in response to Digvijay Singh )Also you would need change in script to get the desired result, since Company is different for one of the matching date, it won't be counted for different companies.
normally the set expression syntax when matching fields is something like this -
count({<period_1={"=period_1=period_2"}>}channel)
-
Re: help set analysis
EZEQUIEL CONTE Feb 9, 2018 11:51 AM (in response to Digvijay Singh )Thank you very much!!!
In case it was not clear: what I'm looking for is that when I select a value from the field "period_name" (which is associated with the period_1 field of table 1), I'll look for that same value in table 2 and when I find it return the channel.
Example:
I select Feb-2017, it will search table 2 for the 201702 value (which comes from table 1), and it returns channel 3.
The idea is not to modify the data model and calculate it with the set analysis.
Thank you very much again!!!
-
-