Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
gerrycastellino
Creator III
Creator III

How to display 2 years of data when one is selected in list box

How do I show my year sales as bar chart as in the below example on left in a bar chart when I have only 1 year selected.

qvw file attached.

sales_year.JPG

sales_year2.JPG

1 Solution

Accepted Solutions
arulsettu
Master III
Master III

5 Replies
arulsettu
Master III
Master III

check this

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Hi use this expression:

sum( {<Year={'2014','2015'}>}Sales)

Regards,

Nagarjuna

jvishnuram
Partner - Creator III
Partner - Creator III

Hi Gerry,

Use the following expression

Sum({$<Year={">=$(Max(Year)-2)<=$(Max(Year))"}>}Sales)

gerrycastellino
Creator III
Creator III
Author

perfect !

ecolomer
Master II
Master II

Two solutions

p58.png