topic Re: Inputbox for equal, less and greater than and Set Analysis in QlikView

Inputbox for equal, less and greater than and Set Analysis

Wed, 16 Jan 2013 16:03:47 GMT

Hi all!

Please help me.

I have Sales and I want to get sales where sales >,<,=N

I use 2 inputboxes for input “>,<,=” and for input TestNum =“N”.

I use expression =If(sum(Sales)>TestNum, sum(Sales)) and If(sum(Sales)<TestNum. It works.

I wanna use set analysis, but it works only witth 'If'. See attachment.

Re: Inputbox for equal, less and greater than and Set Analysis

Anonymous — Wed, 16 Jan 2013 16:38:40 GMT

I don't think you can put an aggregating expression on the left of a comparison in set analysis, such as you do with the vSales variable which equals sum(Sales). Instead a field is expected.

Jonathan

Re: Inputbox for equal, less and greater than and Set Analysis

Wed, 16 Jan 2013 16:45:15 GMT

Hi,

Try this set analysis.

For '>'

=sum( {<Category={"=sum(Sales)>$(TestNum)"}>}Sales)

For '<'

=sum( {<Category={"=sum(Sales)<$(TestNum)"}>}Sales)

Sean

Re: Inputbox for equal, less and greater than and Set Analysis

erichshiino — Wed, 16 Jan 2013 17:58:56 GMT

Sean's example can be adjusted to be used without if:

=sum( {<Category={"=sum(Sales)$(Test)$(TestNum)"}>}Sales)

The expression will use < or > in the variable Test directly

Hope it helps

Erich

Re: Inputbox for equal, less and greater than and Set Analysis

Thu, 17 Jan 2013 07:11:34 GMT

Thank you!

Re: Inputbox for equal, less and greater than and Set Analysis

Thu, 19 Sep 2013 10:06:49 GMT

Hi Erich,

I am trying to automate the greater than or less than symbol as you suggested .But its not working.

Expression:

if(aggr(($(RevenueC)+$(Forecast)),[Parent Customer])$(Vsymbol)$(AcctSizeDL),$(RevenueC)+$(Forecast))

AcctSizeDL

Pick(Match(vAcctSize,'Accounts With>5M Revenue','Accounts With > 1M Revenue','Accounts With < 1M Revenue','All Accounts'),'5000000','1,000,000','1,000,000')

Vsymbol

Pick(WildMatch(vAcctSize,'*>*','*<*'),'>=','<','>=')

Please let me know what mistake i have done