Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
bvssudhakar
Creator III
Creator III

Result Set is not getting properly in if condition

Hi Community,

 

I Have one variable named as 'v_PortfolioManagerId'... I want to use this variable for filter pane so that i have created measure like this : if(PortfolioManagerId=v_PortfolioManagerId, CycleID) 

 

Now I want add one more condition for this filter 'if(GetFieldSelections(PortfolioManager)<>null()' it should show all cycledID's  otherwise it should show this condition cycleid's only if(PortfolioManagerId=v_PortfolioManagerId, CycleID)

 

I tried these two expressions but i am not getting the result set properly.... Can you guys please check and let me know what i missed. Itried all these Expressions

If(Len(Trim(PortfolioManager)) =0,if(PortfolioManagerId=v_PortfolioManagerId, CycleID),CycleID)

if(PortfolioManagerId<>v_PortfolioManagerId and GetFieldSelections(PortfolioManager)<>null(), CycleID,if(PortfolioManagerId=v_PortfolioManagerId, CycleID))

 

 

Can you guys please help me out from this

 

Thanks In Advance

B V S S

0 Replies