Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

Point-in-time reporting

Hi,

I have the impression that this chapter in the book "QlikView 11 for developers" is pretty complicated.

I have - or rather, an external consultant has - done this in a much easier way, without defining fields to disregard and stuff. In the meantime I've changed it, but here it is:

A set identifier expression for the previous month (based on a selection on a field >month< can come down to the following:

>>  Monat = {$(=Month(addmonths(min(Datum_final), -1)))}  << - where >Datum_final< is my date field which the month is of course calculated from.

This does not work, however, when you have no selections at all - one would have to nest this inside an IF condition using the Getcurrentselections function to find out whether or not any selection has been done.

I hope this might help someone.

Best regards,

DataNibbler

0 Replies