topic Re: How to reduce my table report require 5 expression to 1 expression ? in QlikView

How to reduce my table report require 5 expression to 1 expression ?

paulyeo11 — Tue, 21 Apr 2015 18:35:09 GMT

Hi All

I have a P&L Table , which can display correct figure i want. but if i need to display last 5 month data , i need 5 expression . May i know how to make it only using 1 expression ? and i just need to add YearMonth at Diamension ?

In my next posting i will enclosed my QV Doc.

Paul

Re: How to reduce my table report require 5 expression to 1 expression ?

paulyeo11 — Tue, 21 Apr 2015 18:35:54 GMT

Enclosed my QV Doc

Re: How to reduce my table report require 5 expression to 1 expression ?

Anonymous — Tue, 21 Apr 2015 18:43:31 GMT

Hi Paul,

I guess you're looking for this:

money(

sum({$< year=, month=, MonthSeqNum = {"$(= '>=' & only(MonthSeqNum-4) & '<=' & only(MonthSeqNum))"} >} Amount/$(ColumnDim98)/1000)

, $(vMoneyFormatK_GL))

Re: How to reduce my table report require 5 expression to 1 expression ?

paulyeo11 — Tue, 21 Apr 2015 19:19:52 GMT

Hi Michael

Thank you very much. it work !

Paul

Re: How to reduce my table report require 5 expression to 1 expression ?

paulyeo11 — Tue, 21 Apr 2015 19:48:27 GMT

Hi Michael

May I ask . I notice that last week you reply post . And you send me file attachments. The file name are all number.

May I know the meaning of number ? As it is not date. Also not the track number....

Sent from Samsung Mobile

Re: How to reduce my table report require 5 expression to 1 expression ?

Anonymous — Tue, 21 Apr 2015 20:01:38 GMT

Paul, it's the ID number of the discussion, I take it from URL.