Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Valued Contributor

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
Highlighted
Valued Contributor

Re: Can a bar chart be converted to Straight table ?

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
Highlighted
Valued Contributor

Re: Can a bar chart be converted to Straight table ?

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.

Highlighted
Honored Contributor III

Re: Can a bar chart be converted to Straight table ?

Yes, check this

Highlighted
Valued Contributor

Re: Can a bar chart be converted to Straight table ?

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

Highlighted
Valued Contributor

Re: Can a bar chart be converted to Straight table ?

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

Highlighted
Valued Contributor

Re: Can a bar chart be converted to Straight table ?

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

Highlighted
Valued Contributor

Re: Can a bar chart be converted to Straight table ?

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

Highlighted
Valued Contributor

Re: Can a bar chart be converted to Straight table ?

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?

Highlighted
Valued Contributor

Re: Can a bar chart be converted to Straight table ?

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

Highlighted
Valued Contributor

Re: Can a bar chart be converted to Straight table ?

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.