Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Chat Generation

how  to generate like this

5 Replies
swuehl
MVP
MVP

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.

Anonymous
Not applicable
Author

this structure i want in chart

swuehl
MVP
MVP

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

Anonymous
Not applicable
Author

datamodel.bmp

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

swuehl
MVP
MVP

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.