Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

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

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

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

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

Hi Paul,

I guess you're looking for this:

money(

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

, $(vMoneyFormatK_GL))

5 Replies
paulyeo11
Valued Contributor II

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

Enclosed my QV Doc

mov
Esteemed Contributor III

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

Hi Paul,

I guess you're looking for this:

money(

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

, $(vMoneyFormatK_GL))

paulyeo11
Valued Contributor II

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

Hi Michael

Thank you very much. it work !

Paul

paulyeo11
Valued Contributor II

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

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

mov
Esteemed Contributor III

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

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

Community Browser