Chart format

[VishalWaghole]

Hi Community,

I want Chart format like this

	Opening Balance ( till month Mar - 13)	Apr - 13	May -13	Jun - 13	Total
Total No. of files
File With Exception
File Without Exception
Total Queries raised
Total Errors for Calculation
Queries Closed

In this charts all are expressions. No single Dimension here.

Please if any one know then help me.

Thanks and Regards,

Vishal Waghole.

[jagan]

Hi Vishal,

It is not possible in a single chart, you have to use individual textboxes for all the cells, values or else use ValueList() as dimension. 

Check this

http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/01/valuelist-for-those-tricky-situations

Regards,

Jagan.

[Clever_Anjos]

Create an inline table and use it as a dimension

LOAD * INLINE [

    F1

    Opening Balance (till month Mar-13)

    Apr-13

    Mar-13

    Total

];

At presentation tab of your straight table, mark it as 'Horizontal'

[#4]

Hi,

   Please find the image select horizontal box and apply the settings hope it is helpful.

[tresesco]

Did not your early post solution work ? See my last attachment there.

[suniljain]

Month is dimension in you case. you can do it in pivot tabel.

[qlikpahadi07]

your answer is YES, but don't tell how rather attach a Sample data.

Above out put can be Easily Obtained by Cross Table Concept.

[abeyphilip]

Hi Vishal,

Load inline the items in the first column (Total No of file, etc..) as Dim1.

Keep Dim1 as your dimension.

Write separate expressions for Opening Balance, Apr 13, May 13 and Jun 13.

Within expression - have "if loops" for each of the dimensions values.

The months, you will have to make the labels dynamic based on your requirement - let me know if you need help on that.

Regards,

Abey

[jonathandienst]

Hi

You can display a single row or line in a chart without a dimesion (ie only expressions), but you cannot create a table that way.

You could create the columns dimension in an inline script, and use expressions to create the rows in a pivot table. The expressions might need to have pick(ColumnNo(), expr1, expr2, ...) type of structure, to create the columns.

Remember to drag the dimension line the top of the box to arrange them as columns.

Regards

Jonathan

[karolina_]

Maybe try a straight table with dimenstion:
=valuelist('Total No. of files','File With Exception','File Without Exception','Total Queries raised','Total Errors for Calculation','Queries Closed')

and then do 5 expresion,first 4 having definition like:
=if(valuelist('Total No. of files','File With Exception','File Without Exception','Total Queries raised','Total Errors for Calculation','Queries Closed')='Total No. of files', your_expression,
if(valuelist('Total No. of files','File With Exception','File Without Exception','Total Queries raised','Total Errors for Calculation','Queries Closed')=File With Exception', your_next_expression,
etc

and for last
=column(1)+column(2)+column(3)+column(4)