Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

paulyeo11
Valued Contributor II

when i select mth=2 yr=2014 it How to make it sum from 2013 jan till 2014 Feb ?

Set command how to make it can sum sales from date i click ?

Hi All

I have the SET expression , which is half okay :-

sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}[TOTAL_AMT]/1000)

Can some one help to modify the expression , so that it can sum from date i selected.

Now when i select year=2014 & month = Feb , it will sum from :-

2014 jan till Feb

2013 Jan till Feb

what i need is it will sum :-

2014 jan till Feb

2013 Jan till Dec

Paul

2 Replies
paulyeo11
Valued Contributor II

Re: when i select mth=2 yr=2014 it How to make it sum from 2013 jan till 2014 Feb ?

Enclosed my QV doc

paulyeo11
Valued Contributor II

Re: when i select mth=2 yr=2014 it How to make it sum from 2013 jan till 2014 Feb ?

Can any one help me ?

Community Browser