topic Defualt slction in bar graph in QlikView

Defualt slction in bar graph

yogitamehta10 — Thu, 16 Nov 2017 16:07:02 GMT

Hi All,

I just have one small issue ,

I have year dimension (listbox) that has three field Last year, current year and Last cycle.

i want my bar graph to set condition if nothing is selected then show last year data other depending upon user selection from filter.

Anil_Babu_Samineni — Thu, 16 Nov 2017 16:10:11 GMT

Simply do this? Change accordingly

If(GetFieldSelections(Year)>0, Sum(Sales), Sum({<Year = {'$(=Max(Year-1))'}>} Sales))

yogitamehta10 — Thu, 16 Nov 2017 16:20:07 GMT

but in your expression we are not giving by default Last year data otherwise depending upon user selection.

and my year field is basically character that says last year , current year or last cycle

Anil_Babu_Samineni — Thu, 16 Nov 2017 16:25:33 GMT

Not really sure, What your intend here

If(GetFieldSelections(Year)>0, Sum(Sales), Sum({<Year = {'last year'}>} Sales))

its_anandrjs — Thu, 16 Nov 2017 16:30:28 GMT

Better you can do this way by writing two expressions and use a conditinal option in bar chart expressions.

Expression1:-

=SUM(Sales)

And

Conditional:-

=GetSelectedCount(Year)=1

Expression2:-

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

And

Conditional:-

=GetSelectedCount(Year)=0

yogitamehta10 — Thu, 16 Nov 2017 16:35:24 GMT

Apologies I got it , seems like I'm not in working mood:)