topic Re: COULDN'T SOLVE THIS FROM PAST 1 WEEK : How to make a straight table with sparkline when more than one calculated metrics are present? in QlikView

COULDN'T SOLVE THIS FROM PAST 1 WEEK : How to make a straight table with sparkline when more than one calculated metrics are present?

Sat, 28 Jul 2012 07:20:13 GMT

Hi All,

I want sparkline representation in my straight table, plz let me know if it is possible when 3 different calculated metrices(AB, B-C, AB/(B-C)) are present.

Quarter(Dimenssion)	AB	B-C	AB/(B-C)
Q8
Q7
Q6
Q5
Q4
Q3
Q2
Q1

Now i need to display my table in this format:

Metrics	Q8	Q7	Q6	Q5	Q4	Q3	Q2	Q1	Sparkline
AB
B-C
AB/(B-C)

I have attached a sample file.

Please let me know if anyone has any idea.

Regards

Sagar Gupta

Re: COULDN'T SOLVE THIS FROM PAST 1 WEEK : How to make a straight table with sparkline when more than one calculated metrics are present?

Lee_Matthews — Tue, 31 Jul 2012 22:26:56 GMT

Sagar

Mini-charts do not like expressions that reference other expressions. Re-do your mini-chart expression using only field names and it should work.

Re: COULDN'T SOLVE THIS FROM PAST 1 WEEK : How to make a straight table with sparkline when more than one calculated metrics are present?

Tue, 07 Aug 2012 07:47:03 GMT

how many Quarter have you got? only this 8 or it should be automatic? (automatic will be more difficult)

Re: COULDN'T SOLVE THIS FROM PAST 1 WEEK : How to make a straight table with sparkline when more than one calculated metrics are present?

Tue, 07 Aug 2012 11:05:30 GMT

Hi Pari,

I only have 8 Quarters

Regards

Sagar Gupta

Re: COULDN'T SOLVE THIS FROM PAST 1 WEEK : How to make a straight table with sparkline when more than one calculated metrics are present?

Tue, 07 Aug 2012 11:43:01 GMT

as far as i'm concerned ...

there is no other option than :

- Q1, Q2,......Q8 must be expressions

and metrics should be dimensions