Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

How to have 2 expressions in one?

Hi,

I hope you are doing great.

I have two questions:

1. I have 1 expression but I need to add an additional condition inside the expression? I need to count all the closure codes that are equals to Escalation Request and just display it from past 6 months, I need to mix these 2 expressions in one:

Count({$<[Closure Code] = {'Escalation Request'}>} DISTINCT CustomID)

=Count({$<CustomID = {"=Date#(YRMON, 'YYYY-MM') > MonthStart(Today(), -7)"}>} CustomID)  

2. How can I remove the current month on the above expression? I need that November information is not displayed (YRMON is the field used).

Any ideas?

1 Solution

Accepted Solutions
Highlighted

May be this:

Count({$<CustomID = {"=Date#(YRMON, 'YYYY-MM') > MonthStart(Today(), -7) and Date#(YRMON, 'YYYY-MM') < MonthStart(Today()) and [Closure Code] = 'Escalation Request' "}>} CustomID)

View solution in original post

4 Replies
Highlighted

Maybe try this..

=Count({$<[Closure Code] = {'Escalation Request'},
YRMON={
">=$(=MonthStart(Today(), -7))<=$(=MonthEnd(Today(), -1))"
}={>} DISTINCT CustomID)

Highlighted
Creator II
Creator II

I got an Allocated Memory Exceeded message on the chart.

Highlighted
Creator II
Creator II

The second expression is causing the message.

Highlighted

May be this:

Count({$<CustomID = {"=Date#(YRMON, 'YYYY-MM') > MonthStart(Today(), -7) and Date#(YRMON, 'YYYY-MM') < MonthStart(Today()) and [Closure Code] = 'Escalation Request' "}>} CustomID)

View solution in original post