topic Re: barchart exp in QlikView

barchart exp

d_koti24 — Sat, 21 Jun 2014 12:13:16 GMT

I have requirement like bar chart should display sales of latest year sales(by default).But the

year goes to next year if data is get changed then it should be automatically get changed. client

no need to come to us for changing date .So I want data to be year to be changed dynamically,

suppose I have sent you biggest year is 2011. So by default I want that.

Check the screen shot and find Data source.

sundarakumar — Sat, 21 Jun 2014 12:22:31 GMT

this can be done with set analysis

sum({<year={$(=max(year))}>}sales)

Reagrds,

Sundar

Sat, 21 Jun 2014 17:40:08 GMT

HI,

Try this,

Sum({<Year = {'$(=Max(Year))'}>} Sales)

If the max year would not be change even you do filter on date filed then try the below.

Sum({1<Year = {'$(=Max(Year))'}>} Sales)

d_koti24 — Tue, 24 Jun 2014 09:15:27 GMT

Thank u boss