topic Re: reg-straight table in QlikView

reg-straight table

Mon, 03 Mar 2014 04:47:22 GMT

hi all i have few questions recording straight table and i have attached an sample pic and i want to do like that can anyone help me recording this

1.i want to get a separator for each product as shown in pic

2. i want to merge multiple rows into single like as shown in the sample pic

and both i should get in the straight table

Re: reg-straight table

Mon, 03 Mar 2014 05:09:14 GMT

I think the best way is to use a pivot table object instead a straight table.

Re: reg-straight table

sebastiandperei — Mon, 03 Mar 2014 05:11:42 GMT

The first column is a Dimention or a Expression one?

Re: reg-straight table

Mon, 03 Mar 2014 05:15:07 GMT

QUARTER AND MONTH ARE THE DIMENSIONS

Re: reg-straight table

sebastiandperei — Mon, 03 Mar 2014 05:21:36 GMT

I guess you have only one dimmention, with both quarter and months.

You could put an expression with =' ' between the products expressions, and fill it with a color, open the symbol in that expression, and in "Background Color", set with RGB(red_value, green_value, blue_value) which you want.

I cant understand your second request

Re: reg-straight table

Mon, 03 Mar 2014 05:26:34 GMT

first column is expression and quarter and months are the dimensions

Re: reg-straight table

Mon, 03 Mar 2014 05:31:41 GMT

in second one i want to add multiple measures of product to merged in to single row as shown in fig b

Re: reg-straight table

Mon, 03 Mar 2014 05:47:23 GMT

hi if am using that expression what you said it is going to change whole cell but i want only dark like above the product only

Re: reg-straight table

sunilkumarqv — Mon, 03 Mar 2014 06:01:19 GMT

Hi Mvr,

I dont think will get those functionalities instead of that you use color borders for that firstly create Ids in your database IN + Experssion tab background color,Text color,Text Format below see sample

how Id related to background color,Text color,Text Format

background color

=If(RowNo(Total)=ID or

RowNo(Total)=ID or

RowNo(Total)=ID,RGB(203,235,245))

= If(RowNo(Total)=1 or

RowNo(Total)=5 or

RowNo(Total)=9 or

RowNo(Total)=15 or

RowNo(Total)=16 or

RowNo(Total)=17 or

RowNo(Total)=18 or

RowNo(Total)=19 or

RowNo(Total)=20 or

RowNo(Total)=30 or

RowNo(Total)=31, '<B>')

If(RowNo(Total)=5 or

RowNo(Total)=9 or

RowNo(Total)=15 or

RowNo(Total)=16 or

RowNo(Total)=17 or

RowNo(Total)=19 or

RowNo(Total)=30 or

RowNo(Total)=31,'<I>')

Re: reg-straight table

Mon, 03 Mar 2014 06:01:37 GMT

I can reach that so far. To be able to collapse, I should have Price and Volume like a dimension and not a metric Name,

Re: reg-straight table

Mon, 03 Mar 2014 06:09:20 GMT

HI Eva but i want to get the price ,volume under synagis product only in single row

Re: reg-straight table

Mon, 03 Mar 2014 06:19:45 GMT

Something like that? for the collapse.

If you want both fields in the same column, Qlikview cannot make the difference between both... or yes, buth I don't know how... Let me search a little bit.

Re: reg-straight table

Mon, 03 Mar 2014 06:21:58 GMT

hi Eva you have did volumes,price in separate column but i want that under sevo product only in single row

Re: reg-straight table

Mon, 03 Mar 2014 06:23:49 GMT

Hi sorry, I didn't see your answer before posting... Let me see if we can do something.

Why do you need a straight table?

(my example is a pivot one)

Re: reg-straight table

Mon, 03 Mar 2014 06:29:37 GMT

i have done everything in straight table only is it possible in straight table

Re: reg-straight table

Mon, 03 Mar 2014 06:33:22 GMT

but quarter is one table and month is one table and if i have selected pivot table and for every quarter and month table the product table is also coming

Re: reg-straight table

Mon, 03 Mar 2014 06:43:10 GMT

Ok, I reach my limits for tonight.

My point is :

- to make the space, you have to go on Properties -> Dimension -> Advance -> Spacing.

In the interface you can only select a number, not a formula, so I don't think you will be able to put Client and Volume and Price... in the same column and make the spacing because there is no difference for QV.

- for the collapse you have to have Price and Volume like a Dimension and not Metric Name and a cross table.

Transform your straight into cross it's just 1 click. Properties -> General -> Pict up the cross one.

the solution RowNo(Total)=xx works only if you have ALWAYS the same number of metrics (Volume, Price...) per product and you have to do that of every single product. (Maybe we can dig into to find a genetic formula if the display fit with your requirements).

(I will be back tmr, end of the day in Oceania see you).

Re: reg-straight table

Mon, 03 Mar 2014 06:50:16 GMT

no it's just a table loaded inline with 16 lines inside.

Calendar:

LOAD * INLINE [

Month, MonthQuarter

1, Q1

2, Q1

3, Q1

4, Q2

5, Q2

6, Q2

7, Q3

8, Q3

9, Q3

10, Q4

11, Q4

12, Q4

1, M1

2, M2

3, M3

4, M4

5, M5

6, M6

7, M7

8, M8

9, M9

10,M10

11,M11

12,M12

];

Re: reg-straight table

Wed, 05 Mar 2014 06:17:29 GMT

Hi, I tried today to, without a better result. Did you get something good?

Eva

Re: reg-straight table

sujeetsingh — Wed, 05 Mar 2014 06:26:17 GMT

SEE THIS MAY IT HELP YOU