topic Re: Filter From Given Period Time which Transaction availavle in QlikView

Filter From Given Period Time which Transaction availavle

vijayit43 — Tue, 29 Jul 2014 11:12:03 GMT

In My Qv Dashboard when we give filter for '01 Apr 2014' to '30 Apr 2014' then show all item(because all items opening available on '01 Apr 2014') but we want to show only these item which transaction are available for given period time, for better clarification attached QV given bellow please any body help .....

Re: Filter From Given Period Time which Transaction availavle

Tue, 29 Jul 2014 11:19:03 GMT

Dear Vijay,

I used the follwing syntax for your ITEMNAME to get the desiered field:

Aggr(Only({<ITEMNAME=>}(ITEMNAME)),ITEMNAME)

Hope that works.

Regards

Re: Filter From Given Period Time which Transaction availavle

vijayit43 — Tue, 29 Jul 2014 11:32:38 GMT

Thanks Sir ............