Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Set Analysis not WorkingMon

Hi

I'm trying to use a set analysis for Selecting the last month minus one of the data that is created in the system1.

I have the following fields:

     System     : indicated where the data comes from. In this case I want to consider only the data with the tag system1

     [ID Month|Year]     : Is a correlative number for add/substract months. i.e I need info from five months ago (1,2,3,4...)

     [Month|Year]:          : The name of the correlative number i.e. Dec-2014, Jan-2014, ....

=MaxString( {1<[System]={"system1"}, [ID Month|Year]={"$(=Max( {$<Month|Year=>}  [ID Month|Year])-1)"}>} [Month|Year] )

This works like a charm, but considers the data from all the systems:

=MaxString( {1< [ID Month|Year]={"$(=Max( {$<Month|Year=>}  [ID Month|Year])-1)"}>} [Month|Year] )


What am I doing wrong?

Help please


Thanks!!

1 Solution

Accepted Solutions
Highlighted
Not applicable

Finally I solved it with the following expression:

=MaxString( {1<[ID Mes|Ano]={"$(=Max( {$<[Sistema de Origen]={"EBI"}, Mes|Ano=>}  [ID Mes|Ano])-1)"}>} [Mes|Ano] )

Hope it Helps somebody

View solution in original post

1 Reply
Highlighted
Not applicable

Finally I solved it with the following expression:

=MaxString( {1<[ID Mes|Ano]={"$(=Max( {$<[Sistema de Origen]={"EBI"}, Mes|Ano=>}  [ID Mes|Ano])-1)"}>} [Mes|Ano] )

Hope it Helps somebody

View solution in original post