topic Re: hide column in straight table if value is '0'(zero) in QlikView

hide column in straight table if value is '0'(zero)

Mon, 06 Feb 2012 06:05:44 GMT

hi Folks,

how can i hide column in straight table if the field value is 0

Re: hide column in straight table if value is '0'(zero)

kaushiknsolanki — Mon, 06 Feb 2012 06:27:57 GMT

Hi,

You can use the conditional show feature of straight table.

Go to properties -> Presentation -> Click on the dimension/expression you want to hide. and type the condition in "conditional".

Regards,

Kaushik Solanki

hide column in straight table if value is '0'(zero)

Mon, 06 Feb 2012 07:08:47 GMT

hi kaushik,

sum(revenue) for account1=40,324 & account 2 revenue=351047,account 3 =199641 like that

while selecting account 1 it displays remaining accounts as '0'

my requirement is it shouldnt show remaining accounts .

Account 1 2 3

1 40,324 0 0

2 0 351047 0

3 0 0 100000

Re: hide column in straight table if value is '0'(zero)

Mon, 06 Feb 2012 07:10:48 GMT

hi kaushik,

sum(revenue) for account1=40,324 & account 2 revenue=351047,account 3 =199641 like that

while selecting account 1 it displays remaining accounts as '0'

my requirement is it shouldnt show remaining accounts .

thanks in advance

Re: hide column in straight table if value is '0'(zero)

kaushiknsolanki — Mon, 06 Feb 2012 07:17:41 GMT

Hi,

Can you please upload sample data.

Regards,

Kaushik Solanki

Re: hide column in straight table if value is '0'(zero)

Mon, 06 Feb 2012 07:40:56 GMT

hi kaushik,

i already attached sample straight table data as excel file,

plz find the attachment above

Re: hide column in straight table if value is '0'(zero)

kaushiknsolanki — Mon, 06 Feb 2012 07:50:36 GMT

Hi,

The xls you had uploaded contains the output you want. Am i right..?

If i m right then i am looking for the raw data.

Also explain indetail with an example what you want cause i am still not clear with your requirements.

Regards,

Kaushik Solanki

Re: hide column in straight table if value is '0'(zero)

Mon, 06 Feb 2012 08:12:15 GMT

hi kasshik,

the excel file is sample straight table data in my qvw.

here my requirement is condition hide of account dimension data.

ex: if i click account 1 it shouldnt display account 2,3 , y because they r 0's

excel sheet itself my sample data in my straight table

Re: hide column in straight table if value is '0'(zero)

kaushiknsolanki — Mon, 06 Feb 2012 08:35:01 GMT

Hi,

Have a look at the sample application attached here with.

Regards,

Kaushik Solanki

Re: hide column in straight table if value is '0'(zero)

Mon, 06 Feb 2012 08:41:01 GMT

thanks kaushik,

its worked fine