Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi Folks,
how can i hide column in straight table if the field value is 0
Hi,
Have a look at the sample application attached here with.
Regards,
Kaushik Solanki
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
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
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
Hi,
Can you please upload sample data.
Regards,
Kaushik Solanki
hi kaushik,
i already attached sample straight table data as excel file,
plz find the attachment above
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
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
Hi,
Have a look at the sample application attached here with.
Regards,
Kaushik Solanki
thanks kaushik,
its worked fine