Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
raghavsurya
Partner
Partner

how to exclude a value in textbox

Hi All,

We currently have a situation wherein the graphs and charts in one of the tab does not have details for one of dimension value present in a list box. Hence we want to hide the value in the list box. Is there a way to do it.

Can anybody help me.

Regards,

Raghav

12 Replies
Not applicable

Hi ,

Answer suggested by Tresesco is almost right but instead of using 2011 has hardcode you need to check the value in any of you key which doesn't have the data for future like ur key or the transaction value.. hence the formula can be

If(Len(TransactionAmount)>0,Year)

Note : TransactionAmount is just an asumption of the field.. Rest follow the steps suggested by Tresesco..

sathishkumar_go
Partner
Partner

HI Raghavsurya,

If i understood ur problem correctly,

then try this,

in load script itself restrict the year 2011 in year field and put alias some other name.

then in particular tab call that field in year.

Ex:

fiscal Cal:

year,

if(year <> 2011,year) as year_New

so in ur table u have 2 year fields 1 is containing 2011 and 1 is not 2011.

Regards

Sathish

raghavsurya
Partner
Partner
Author

Thanks a lot for your kind help.

Regards,

Raghav