topic Equating variable to a function in set analysis in QlikView https://community.qlik.com/t5/QlikView/Equating-variable-to-a-function-in-set-analysis/m-p/1227146#M391507 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have a data set with date wise data of Districts and their corresponding territories.</P><P>The territories and the corresponding district has the same alphabet in common.(G in case of the example attached).</P><P>But, i have some more territories(which belong to some other district) but are temporarily aligned to this district.</P><P>My requirement is, that i don want to aggregate the data of this territory in the rollup, but the data of this territory should show up only when that territory is selected.</P><P>I don want to hard code this, as there will be numerous cases in the actual dataset.</P><P>I am trying to put this in set analysis, using wildmatch/mid function so that i can compare the Alphabet in the territory and the district.</P><P></P><P>But i am facing problems in the same.</P><P></P><P>Please have a look at the attached sample.</P><P></P><P>Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 25 Nov 2016 06:51:50 GMT chhavi376 2016-11-25T06:51:50Z Equating variable to a function in set analysis https://community.qlik.com/t5/QlikView/Equating-variable-to-a-function-in-set-analysis/m-p/1227146#M391507 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have a data set with date wise data of Districts and their corresponding territories.</P><P>The territories and the corresponding district has the same alphabet in common.(G in case of the example attached).</P><P>But, i have some more territories(which belong to some other district) but are temporarily aligned to this district.</P><P>My requirement is, that i don want to aggregate the data of this territory in the rollup, but the data of this territory should show up only when that territory is selected.</P><P>I don want to hard code this, as there will be numerous cases in the actual dataset.</P><P>I am trying to put this in set analysis, using wildmatch/mid function so that i can compare the Alphabet in the territory and the district.</P><P></P><P>But i am facing problems in the same.</P><P></P><P>Please have a look at the attached sample.</P><P></P><P>Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 25 Nov 2016 06:51:50 GMT https://community.qlik.com/t5/QlikView/Equating-variable-to-a-function-in-set-analysis/m-p/1227146#M391507 chhavi376 2016-11-25T06:51:50Z