topic Re: straight table in QlikView

straight table

Wed, 30 Apr 2014 09:26:20 GMT

Hi Team

I have a straight table which is having 25 rows

can we delete certain rows in the straight table, how can we do

regards

Pnreddy

Re: straight table

lukaspuschner — Wed, 30 Apr 2014 09:27:27 GMT

can you attatch the file and explain which rows you want to delte?

Re: straight table

MK_QSL — Wed, 30 Apr 2014 09:28:46 GMT

You can load certain rows...

consider that you wants to load only three customer out of five as C1, C2, C3, C4, C5

Use Calculated Dimension

If(Match(Customer,'C1,'C2,'C3),Customer)

Tick Suppress When Value is null

Expression May be something like SUM(Sales)

This will load only data for customer C1, C2 and C3.

Re: straight table

its_anandrjs — Wed, 30 Apr 2014 09:30:23 GMT

Use calculated dimension for that or if have a sample data so provide that.

Re: straight table

Wed, 30 Apr 2014 09:35:47 GMT

in those customers i want to delete only c3 how can we do

Re: straight table

its_anandrjs — Wed, 30 Apr 2014 09:37:56 GMT

Updated now check

Write like

If( Not Match(customers,'c3'),customers) in the dimension

If(customer <> 'C3', customer)

Re: straight table

SunilChauhan — Wed, 30 Apr 2014 09:38:05 GMT

if some values are null then

go to presentation tab -> select field and check Omit when null

Re: straight table

MK_QSL — Wed, 30 Apr 2014 09:39:23 GMT

IF(Customer <> 'C3', Customer)

If(NOT Match(Customer,'C3),Customer)

TIck Suppress When Value is NULL

Re: straight table

jonathandienst — Wed, 30 Apr 2014 09:40:37 GMT

Calculated dimension:

= If(Customer <> 'C3', Customer)

=Aggr(If(Customer <> 'C3', Customer), Customer)

And check suppress nulls for that dimension.

HTH

Jonathan

Re: straight table

Wed, 30 Apr 2014 09:41:47 GMT

i want to delete bello a4 row what to do

Re: straight table

Wed, 30 Apr 2014 09:47:43 GMT

Thank You

Re: straight table

Wed, 30 Apr 2014 09:47:54 GMT

Thank You

Re: straight table

its_anandrjs — Wed, 30 Apr 2014 09:48:40 GMT

Updated now check

Write dimension like

If( Not Match(A,'a4'),A) in the dimension

and select Suppress when value is Null

Re: straight table

Anonymous — Wed, 30 Apr 2014 09:48:46 GMT

Like everyone else says, do it by

- not loading it in the data in the first place (where clauses, match(), if() and so on)

- by making an expression in the straight table resulting in the row(s) not being displayed

- by doing selections in the straight table.

I think the best solution for you depends on WHY you want to delete/hide the row(s), cause I'm not fully understanding your requirement. Should it be present in the data at all, is it during navigation/analysis you want to disregard the row etc.

/Nicolai

Re: straight table

Wed, 30 Apr 2014 09:51:57 GMT

i have one more question

can we foramat the straight table as below

Re: straight table

MK_QSL — Wed, 30 Apr 2014 10:02:04 GMT

Go to style tab and select from Current Style

Re: straight table

Anonymous — Wed, 30 Apr 2014 10:58:17 GMT

What formatting are you looking for specifically?

- the bold headers

- the separated "$ 105" values

- the conditional coloring of the rows

- no row borders?

Remember besides style, you get more options for formatting when design grid is activated, e.g. custom format cell when right clicking the cells.