How to make Sparkline bar chart in Table?

[#1]

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

[jjfabian]

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

[deepakk · Accepted solution]

hi Sagar,

I have attach a sample application.

I hope the application is what you are looking for.

Deepak

[#4]

Thanks a lot Deepak.

I was strugling with it from 2-3 hours.

Once again Thanks

[#5]

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