Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try;
sum({< DateField={">= $(=addMonths(max(DateField),-1)) <= $(=max(DateField))"} >}YourMeasure)
Hi,
are you making selections on the Date field ?
yes, date field is my only dimension
you can add this to your measure to detach your month field or date field selection:
aggr_function( {<Date_field=>} Measure)
try;
sum({< DateField={">= $(=addMonths(max(DateField),-1)) <= $(=max(DateField))"} >}YourMeasure)
this should be added in measure? am I right
Yes; please refer to this thread:
it should guide how and when/where to use such expressions !
Hope it would be useful
thanks for your replies, I will check it out