New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

Set Analysis with Revenue Variable

Hello,

We have changed our revenue to a variable calculation. I am trying to enter in an equation that will use our revenue variable and work within the following set analysis. When I update to the variable, I get 0's, so I am not sure if it is working correctly. Any thoughts would be great thanks!

Before:

=sum({\$<[Year Breaks]={"0-2 years"}>}[Revenue (dollars)])

Attempt:

=sum({\$<[Year Breaks]={"0-2 years"}>}\$(vRevenue\$))

Tags (1)
4 Replies
MVP

Re: Set Analysis with Revenue Variable

How do you set the variable ?

Contributor

Re: Set Analysis with Revenue Variable

I set the variable to look at budgeted and actual based on years.

Variable:

if(sum(if(Year>2016 and [Financial View]='Budgeted',[Revenue (dollars)],if(Year<2017 and [Financial View]='Actual',[Revenue (dollars)],0)))=0, '-',

sum(if(Year>2016 and [Financial View]='Budgeted',[Revenue (dollars)],if(Year<2017 and [Financial View]='Actual',[Revenue (dollars)],0))))

New Contributor

Re: Set Analysis with Revenue Variable

Hi Russell,

This will work for you:

=sum({\$<[Year Breaks]={'0-2 years'}>} \$(vRevenue))

While caculating the variable, use = sign before the calculation in variable overview window. Like vRevenue = sum(Revenue).

Contributor

Hi Prabhakar,