topic Re: How to make Sparkline bar chart in Table? in QlikView

How to make Sparkline bar chart in Table?

Thu, 28 Jun 2012 03:34:47 GMT

Hi Guys,

I want to display sparkline in my straight table with the data in this format.

Header 1	Header 2	Header 3	Header 4	Header 5	Header 6	Header 7	Header 8	Header 9
Metrics	Q7	Q6	Q5	Q4	Q3	Q2	Q1	Sparkline
A	43	547	70	89	678	875	678	( bar chart)
B	346	456	67	789	45	34	24	( bar chart)

I want Bars in such a way that each bar should be for one Quarter for that metrics( in this case for A,B....................)

Please reply as soon as possible.

Regards

Sagar Gupta

Re: How to make Sparkline bar chart in Table?

jjfabian — Thu, 28 Jun 2012 07:38:29 GMT

Hi Sagar,

Assuming your A, B and Quarter are dimensions you will have to duplicate your expression and display itas a minichart (select minichart from the representation dropdown). Once you have created the minichart, you can change the format to sparkline and add your Quarter dimension as a dimension.

Now the only thing you will have to add to your expressions is a set analysis part telling the expression to ignore the quarter dimension, otherwise your minichart will not display correctly.

Jakob

Re: How to make Sparkline bar chart in Table?

deepakk — Thu, 28 Jun 2012 07:45:13 GMT

hi Sagar,

I have attach a sample application.

I hope the application is what you are looking for.

Deepak

Re: How to make Sparkline bar chart in Table?

Thu, 28 Jun 2012 11:16:38 GMT

Thanks a lot Deepak.

I was strugling with it from 2-3 hours.

Once again Thanks

Re: How to make Sparkline bar chart in Table?

Thu, 05 Jul 2012 16:30:48 GMT

sagar guptha i need a help from you regarding this qlik view . can i have ur ph num pls?

but it is urent and needed verymuch. please help me or mail me at jagathi100@gmail.com.

reply me fast please