topic Display the Missing values in QlikView

Display the Missing values

Thu, 05 Dec 2013 07:25:56 GMT

Hi All,

I have two tables one is Demand, other one is Given

Demand table contains Project Number, SPID, Mgr, Month, Demand

Given table contains Project Number,PID, Month,Given

i want to display Mgr wise Given and Demand details as follows

this is done, But my req is i want to display only the values which are 0(Zero) in Given column or (missed data from Given data when compare to Demand Data) with respect to Mgr as follows

I attached Sample QVW and Data file, Please have a look into this req and give me some suggestion.

Thanks,

Chiru

Re: Display the Missing values

karolina_ — Thu, 05 Dec 2013 08:13:10 GMT

Please check attachement.
Is it what you expect?

Re: Display the Missing values

Thu, 05 Dec 2013 08:55:28 GMT

Hi Karolina,

Thanks for reply, But my req is here PID and SPID are same you can observe PID 3,7,8,9 are not existed in Given Data but they are existed in Demand data.

I want to show the values which are not exists in Given data when compare to Demand data for those values i want to show the field value as zero.

Please help me on this.

Thanks,

Chiru

Re: Re: Display the Missing values

neha_shirsath — Thu, 05 Dec 2013 09:50:36 GMT

Hi Chiru,

Please find the attached file.

Hope it'll help you.

Neha