topic Re: How to modify the below expression with out using month_n ? in QlikView

How to modify the below expression with out using month_n ?

paulyeo11 — Wed, 30 Dec 2015 12:41:25 GMT

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

Re: How to modify the below expression with out using month_n ?

avinashelite — Wed, 30 Dec 2015 12:43:14 GMT

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

Re: How to modify the below expression with out using month_n ?

paulyeo11 — Wed, 30 Dec 2015 12:43:15 GMT

Hi All

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

Paul

Re: How to modify the below expression with out using month_n ?

Anonymous — Wed, 30 Dec 2015 12:45:31 GMT

what exactly you want to achieve?

Are you getting any error with the above expression?

Re: How to modify the below expression with out using month_n ?

paulyeo11 — Wed, 30 Dec 2015 12:50:44 GMT

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

Re: How to modify the below expression with out using month_n ?

paulyeo11 — Wed, 30 Dec 2015 12:52:03 GMT

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

Re: How to modify the below expression with out using month_n ?

paulyeo11 — Wed, 30 Dec 2015 12:56:24 GMT

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

Re: How to modify the below expression with out using month_n ?

sunny_talwar — Wed, 30 Dec 2015 13:41:50 GMT

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))

Re: How to modify the below expression with out using month_n ?

Anonymous — Wed, 30 Dec 2015 13:44:01 GMT

I think he dont want to use Month_n field.

Paul,

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

Re: How to modify the below expression with out using month_n ?

paulyeo11 — Wed, 30 Dec 2015 13:55:00 GMT

Hi sunny

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

Paul

Sent from my iPhone

Re: How to modify the below expression with out using month_n ?

paulyeo11 — Wed, 30 Dec 2015 13:56:12 GMT

Hi balraj

You are right , I don't want use month_n field to achieve same result.

Paul

Sent from my iPhone

Re: How to modify the below expression with out using month_n ?

paulyeo11 — Wed, 30 Dec 2015 13:56:48 GMT

Hi Balraj

I have attach my actual QV doc in above post.

Paul

Sent from my iPhone

Re: How to modify the below expression with out using month_n ?

Kushal_Chawda — Wed, 30 Dec 2015 13:57:29 GMT

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))

Re: How to modify the below expression with out using month_n ?

paulyeo11 — Wed, 30 Dec 2015 14:15:11 GMT

Hi Kush

You got it right , Thank you very much.

money(

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

, $(vMoneyFormatK))

Can you help me convert above expression with out using Year_n

Paul

Re: How to modify the below expression with out using month_n ?

Kushal_Chawda — Wed, 30 Dec 2015 16:58:10 GMT

I think

money(

(Sum({<year={"$(=year(today()))"}>}$(ColumnDim51))/sum({<year={"$(=year(today()))"}>}$(Columndim89)))/1000

, $(vMoneyFormatK))

Re: How to modify the below expression with out using month_n ?

paulyeo11 — Wed, 30 Dec 2015 23:29:41 GMT

HI Sir

thank you , it work fine now

paul