Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

IF with current month condition

Hi, guys!

I have a table as follow:


  

MonthsJanFebMarAprMayJun
BG_benchBench USDBench USDBench USDBench USDBench USDBench USD
Engineering000000
Genesys------
International other------
Kyivstar------
Lindorff------
Telecom------
Ukraine other------
0------
Total000000

I need to write th expression with the condition that if  the month is older than the current month I need to calculate with distinct formula.

Like I have an expression now:

If( Month_name<$(vCurMonth),0,Sum({$<Year={2015}>}Sal*Bench_Data))

vCurMonth= monthname(today())

But this formula isn't working properly.

Any ideas?

1 Solution

Accepted Solutions
PrashantSangle

Hi,

In set analysis add Month_name<$(vCurMonth) condition

try like

If( Month_name<$(vCurMonth),0,Sum({$<Month_name={"<$(=monthname(today()))"},Year={2015}>}Sal*Bench_Data))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

1 Reply
PrashantSangle

Hi,

In set analysis add Month_name<$(vCurMonth) condition

try like

If( Month_name<$(vCurMonth),0,Sum({$<Month_name={"<$(=monthname(today()))"},Year={2015}>}Sal*Bench_Data))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.