Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
narenjln
Creator
Creator

Build the Bar graph to see the total sales for all the category only for last two Years

I am having the Fact Table Like Below format ,

Order ID
Order date

Mobile phone (Cost of Mobile)

Laptop (Cost of Laptop)

TV(cost of TV)

Monitor (Cost of Monitor)

Build the Bar graph to see the total sales for all the category( Mobile phone,Laptop,TV,Monitor)only for last two Years from the current date


using order date i have created the Year

and Using Set Analysis i have capture the last 2 years, but i dont have idea how to display for all the 4 dimentions(Mobile Phone, Laptop,TV,Monitor)

1 Solution

Accepted Solutions
narenjln
Creator
Creator
Author

by using crosstable i am able to achive it

View solution in original post

2 Replies
narenjln
Creator
Creator
Author

using order date i have created the Year

and Using Set Analysis i have capture the last 2 years, but i dont have idea how to display for all the 4 dimentions(Mobile Phone, Laptop,TV,Monitor)

narenjln
Creator
Creator
Author

by using crosstable i am able to achive it