Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to modify the below expression with out using month_n ?

Hi All

How to modify the below expression with out using month_n ?

money(

Sum (if(Month_n=1, $(ColumnDim51)/$(Columndim89))/1000)

, $(vMoneyFormatK))

my next post i will attach my QV Doc

Paul

1 Solution

Accepted Solutions
Kushal_Chawda

Please select the Year =15 & use below expression

money(

(Sum ({<YearMonth={"$(=date(max(YearMonth),'YY MMM'))"}>} $(ColumnDim51))/sum({<YearMonth={"$(=date(max(YearMonth),'YY MMM'))"}>}$(Columndim89)))/1000

, $(vMoneyFormatK))



Capture.JPG

View solution in original post

15 Replies
avinashelite

what is Month_n here ? a dimension? could you please elaborate more  

paulyeo11
Master
Master
Author

Hi All

Reasons i need to remove month_n is because , my GL Table does not link with month_n

Paul

Anonymous
Not applicable

what exactly you want to achieve?

Are you getting any error with the above expression?

paulyeo11
Master
Master
Author

Hi Avinash

if month_n=0 mean current month sales amount

if month_n=1 mean previous month sales amount

and so on.

I aware that SET analysis don't require using month_n.

Paul

paulyeo11
Master
Master
Author

Hi Balraj

I never get any error . i cannot make use of the field name month_n , because i have sales table and GL table , as GL table does not link with month_n

Paul

paulyeo11
Master
Master
Author

i want to achieve the same result $370K with out using month_n field in the exoression.

sunny_talwar

You don't want to use the if statement or you don't want to use month_n?

This seems to be working as well:

=Money(Sum({<Month_n = {1}>}$(ColumnDim51)/$(Columndim89)/1000), $(vMoneyFormatK))

Anonymous
Not applicable

I think he dont want to use Month_n  field.

Paul,

It would be better if you can share some sample data for same

paulyeo11
Master
Master
Author

Hi sunny

I don't want to use month_n , if using month_n existing expression is working fine.

Paul

Sent from my iPhone