Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
chhavi376
Creator II
Creator II

Equating variable to a function in set analysis

Hi all,

I have a data set with date wise data of Districts and their corresponding territories.

The territories and the corresponding district has the same alphabet in common.(G in case of the example attached).

But, i have some more territories(which belong to some other district) but are temporarily aligned to this district.

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.

I don want to hard code this, as there will be numerous cases in the actual dataset.

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.

But i am facing problems in the same.

Please have a look at the attached sample.

Thanks

0 Replies