topic Re: Issue with Rank values in Grid in QlikView

Issue with Rank values in Grid

vijetas42 — Fri, 13 Mar 2015 05:55:01 GMT

Hello All,

I need your suggestions on an issue that I am facing,

my scenario is,

I am having grid in which there are geographies and their ranks

on top of that i am having dropdown for geography selection in that suppose i am having R1 which is Region and Territories like, T1,T2

when I will select T1 it will shows proper Rank along with that geo

but when i select R1-Region in that case in grid it shows min rank value to all territories

my expression is like this min({<help=p(GEO_SK)>}M_RANK)

Convey your opinions,

Thanks!

Gysbert_Wassenaar — Fri, 13 Mar 2015 06:48:27 GMT

I'm afraid I don't understand what you're trying to do. Can you post a qlikview document that demonstrates the problem?

vijetas42 — Fri, 13 Mar 2015 06:52:40 GMT

Hi,

PFA screenshot,

when i select territory my rank is 3

and ,

below is when i select region south east