topic Need Help on Filtering the data Based On Regions...? in QlikView

Need Help on Filtering the data Based On Regions...?

Anonymous — Mon, 08 Jun 2015 10:38:54 GMT

Hi Experts,

Need Help Form you guys regarding the Region wise Agents filter.

Requirement is I have 100 Agents in Region INDIA , After few years 40 Agents Moved to US , Now I want to show All the 100 Agents Names including those who Moved from INDIA also when i Select INDIA , But With Null Values , if I select US it has to show 40 agents Complete data...

Attaching the Sample Qvw: Plz look in to this Observe Agent 1 & 2 , these 2 agents are moved from HYD to H99 ,now if I select HYD it has to show 10 Agents including 1 & 2 also. and it has to display Null values for agents 1 & 2.

when i select H99 it has to disply 1 & 2 Agents with their New Sales..

Help on the Above issue is highly appreciable...

thanks in Advance...

Regards

Anusha.K

Re: Need Help on Filtering the data Based On Regions...?

sushil353 — Mon, 08 Jun 2015 10:44:51 GMT

Hi,

It is better if you share a sample dataset.

Still you can try below solution.

=if(getfieldselection(Region) = 'India',only({<Region=>}AgentsNamefield),AgentsNamefield)

HTH

Sushil

Re: Need Help on Filtering the data Based On Regions...?

MayilVahanan — Mon, 08 Jun 2015 10:45:21 GMT

Please refer below link

Slowly Changing Dimensions

Re: Need Help on Filtering the data Based On Regions...?

hariprasadqv — Mon, 08 Jun 2015 10:54:20 GMT

That's SCD. Follow scd handling mechanisms.

Re: Need Help on Filtering the data Based On Regions...?

Anonymous — Tue, 09 Jun 2015 06:47:58 GMT

Hi Plz find the attached Qvw file with Sample Data...