Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

Can a bar chart be converted to Straight table ?

Hey,

Can a bar chart be converted to Straight table ?  I have Cyclic Dmensions

Thanks

1 Solution

Accepted Solutions
nikhilgarg
Specialist II
Specialist II
Author

Hey,

I did that but i want the sorting in same manner as in bar chart which goes wrong when i converted it to straight table.

Thanks

View solution in original post

20 Replies
morganaaron
Specialist
Specialist

Converted? It all depends on how your data is structured, but there shouldn't be a reason why a bar chart can't become a straight table - you could simply turn on the fast change option and enable both to allow switching between the two? You can have cyclic dimensions in a straight table.

anbu1984
Master III
Master III

Yes, check this

nikhilgarg
Specialist II
Specialist II
Author

Hey,

Thanks . It helped me but now when i am selecting one of the dimension , i am not getting max value at top. While for other two dimensions it works fine.

thanks

nikhilgarg
Specialist II
Specialist II
Author

Hey,

Thanks anbu. But i think Aron reply is more helpful. But now when i am selecting one of the dimension , i am not getting max value at top. While for other two dimensions it works fine.

thanks

morganaaron
Specialist
Specialist

As in it's not sorting the data correctly? What format is the data you're sorting?

nikhilgarg
Specialist II
Specialist II
Author

Actually, in barchart i have cyclic dimensiona nd cyclic expression. There it is sorting in correct manner by both ways.

When i create cyclic dim and expr in straight table, it is not working correctly.

Thanks

morganaaron
Specialist
Specialist

Can you post your .qvw or show a screenshot of what you're using in the sort tab? Are you using an expression or just sorting by default values? Are they numbers?

nikhilgarg
Specialist II
Specialist II
Author

Hey,

I can not post qvw. But ltme tell you:

Cyclic dim = User + Country + Department

Cyclic Expression = Expr 1 + Expr2

Under Sort tab:

1: For Cyclic Dim:  I checked Frequency : Descending

2: For very first expr: i checked Numeric value = Descending

But they are not coming correct order.

thanks

morganaaron
Specialist
Specialist

What are you expecting to see? And what is it showing? Can you give an actual example of the data?

Be aware that sorting your dimension by frequency is equivalent to a count of the expression.