QlikSense Dimension

[navaneeth79]

In Qliksense app for a line chart when we give date field as dimension we are getting only current month data, I want previous month data also, anyone could help me out.

[YoussefBelloum]

Hi,

are you making selections on the Date field ?

[navaneeth79]

yes, date field is my only dimension

[YoussefBelloum]

you can add this to your measure to detach your month field or date field selection:

aggr_function( {<Date_field=>}   Measure)

[OmarBenSalem · Accepted solution]

try;

sum({<  DateField={">= $(=addMonths(max(DateField),-1)) <= $(=max(DateField))"} >}YourMeasure)

[navaneeth79]

this should be added in measure? am I right

[OmarBenSalem]

Yes; please refer to this thread:

YTD, MTD issue

it should guide how and when/where to use such expressions !

Hope it would be useful

[navaneeth79]

thanks for your replies, I will check it out