topic Re: Chat Generation in QlikView

Chat Generation

Anonymous — Fri, 13 Jan 2012 17:11:55 GMT

how to generate like this

Chat Generation

swuehl — Sat, 14 Jan 2012 11:50:56 GMT

Sorry, I don't understand what you want. Could you explain a bit more?

In QV11, there is a server based annotation feature, which could be used for something like a forum / chat / annotations, linked to sheet objects.

If you really need a chat, I would suggest using one of the external chat programs.

Re: Chat Generation

Anonymous — Tue, 17 Jan 2012 16:03:24 GMT

this structure i want in chart

Re: Chat Generation

swuehl — Tue, 17 Jan 2012 16:09:37 GMT

Sorry, I misread your Post header, now I see:

I think you can use a pivot table chart for a table like you attached. First dimension Quarter, second Month.

Then you could use three expression that aggregate your values. I personally wouldn't repeat mn, bn (for million, billion ?) at each line, but just state it at the expression header label.

Not sure if this all is really helpful for you, but without knowing your data (model) and your aggregation needed, I don't know what more to say.

Pivot tables are one of the chart sheet objects types.

Regards,

Stefan

Re: Chat Generation

Anonymous — Tue, 17 Jan 2012 16:22:15 GMT

this is my Daa Model ..if any errors in daa model pls suggest..if you want excel file means ..i will sen to you if you want means

Re: Chat Generation

swuehl — Tue, 17 Jan 2012 17:08:41 GMT

All depends on what you want to achieve, what your requirements are. What are the fields you need to aggregate?

I see that your calendar is only linked by year to Rate table (you only have a year field in Rate table), so I assume it's getting hard to group / evaluate your data per Quarter and Month.

If you want to share some data, that might help, but more important is that you need to know what you want to do with your data.