-
Re: Bar Chart like Pivot Table
Praveena Velagapudi Sep 16, 2016 3:56 PM (in response to Dave Melillo)MONTH , ACCOUNT GROUPINGS--> Dimension
Sum(Sales) --> Expression
Style--> Grouped for separate bars.
-
Re: Bar Chart like Pivot Table
Dave Melillo Sep 16, 2016 4:11 PM (in response to Praveena Velagapudi )Thanks for the answer but that does not work. In your suggestion Sum(Sales) is still on the X- Axis. I am trying to get the MONTH on the axis.
-
Re: Bar Chart like Pivot Table
Digvijay Singh Sep 17, 2016 6:46 AM (in response to Dave Melillo)Are you sure on this, I doubt because if you take Month as first dimension, it will surely be on X Axis. Account grouping if taken as second dimension will be shown using separate bars/stacked bar as per style setting and height of bar on Y-axis will indicate the expression sum(sales) ( as long as you have 2 dim and 1 exp).
If you can share sample, that would be helpful.
-
-
-
Re: Bar Chart like Pivot Table
Anil Babu Sep 16, 2016 11:43 PM (in response to Dave Melillo)As you mention, you created pivot for then right. Would you be to provide that pivot table with us. So that, we can check what you did from there.
Then, we will help you for visualisation
-
Re: Bar Chart like Pivot Table
Vineeth Pujari Sep 17, 2016 6:38 AM (in response to Dave Melillo)promote / demote your dimensions to change your X-axis dimension or download some demos from qlik demos site for reference