topic Re: Set analysis with variable in QlikView

Set analysis with variable

phongnnguyen — Thu, 07 Jun 2018 02:35:28 GMT

Dear guys,

I have a problem with my code to ignore current selection for variable

this is my code: {<BranchName=>}$(v_Interest) - with v_Interest is a variable

thanks for your help

Cheers,

Re: Set analysis with variable

sumit_ranjan_pa — Thu, 07 Jun 2018 05:23:58 GMT

Hi,

Set analysis is always used with calculated dimensions/facts. Your variable need to be encased in some kind of aggregation/calculation function, for it to work.

Similar to this: fact:

sum( {<BranchName=>}$(v_Interest) ) .

This would work fine.

Without the Sum/ count, it get bit tricky. However, if it is a dimension you can try this,

Aggr( Only({<BranchName=>} $(v_Interest) )

Let me know how it works out.

Thanks and regards,

Sumit

Re: Set analysis with variable

phongnnguyen — Thu, 07 Jun 2018 06:18:45 GMT

Thanks for your reply, but this is not working with me.

Actually,

v_Interest = if((interval(min(TradeDate)-CreateDate_Branch,'d'))>0,

sum({<BranchNameAE=>}if( k=0 and Interest>0,-Amount))/count(distinct TradeDate),

sum({<BranchNameAE=>}if( k=0 and Interest>0,-Amount))/NetWorkDays(CreateDate_Branch,max(TradeDate)))

Re: Set analysis with variable

sumit_ranjan_pa — Thu, 07 Jun 2018 10:06:55 GMT

Thank you for the code. Seems from the code, you can simplify it a bit.
You cannot use the set analysis without any aggregation functions. Using variable is fine but it needs to have a function outside.

Seems like you will have to add the values in every Set analysis inside the if condition.

If possible can you share the Application snippet and let us know what exactly you want of the script?

Re: Set analysis with variable

phongnnguyen — Fri, 08 Jun 2018 03:58:07 GMT

Thanks for your information.

Actually, I wanna make the bar chart to show Interest of Branches. When I choose any Branch, I want it will show all Branches not just show currently selected.

v_Interest = if((interval(min(TradeDate)-CreateDate_Branch,'d'))>0,

sum({<BranchNameAE=>}if( k=0 and Interest>0,-Amount))/count(distinct TradeDate),

sum({<BranchNameAE=>}if( k=0 and Interest>0,-Amount))/NetWorkDays(CreateDate_Branch,max(TradeDate)))