topic Re: Chart format in QlikView

Chart format

VishalWaghole — Sun, 29 Sep 2013 08:56:12 GMT

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.

Re: Chart format

jagan — Sun, 29 Sep 2013 15:58:03 GMT

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.

Re: Chart format

Clever_Anjos — Sun, 29 Sep 2013 21:48:38 GMT

Create an inline table and use it as a dimension

LOAD * INLINE [

Opening Balance (till month Mar-13)

Apr-13

Mar-13

Total

];

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

Re: Chart format

Mon, 30 Sep 2013 05:17:26 GMT

Hi,

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

Re: Chart format

tresB — Mon, 30 Sep 2013 05:46:39 GMT

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

Re: Chart format

suniljain — Mon, 30 Sep 2013 06:23:13 GMT

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

Re: Chart format

qlikpahadi07 — Mon, 30 Sep 2013 06:47:46 GMT

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.

Re: Chart format

abeyphilip — Mon, 30 Sep 2013 07:42:56 GMT

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

Re: Chart format

jonathandienst — Mon, 30 Sep 2013 07:47:01 GMT

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

Re: Chart format

karolina_ — Mon, 30 Sep 2013 09:05:14 GMT

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)

Re: Chart format

v_iyyappan — Mon, 30 Sep 2013 09:36:33 GMT

Hi,

Can you clarify for opening balance, Apr-13 to Jun-13? is it dimension or expression?

When u have all are expression means please use the pivot table and drag and drop the expression.

regards,

Re: Chart format

vikasmahajan — Mon, 30 Sep 2013 10:43:23 GMT

Hope this helps you

vikas