topic Re: Show/Hide a field based on selection in QlikView

Show/Hide a field based on selection

raju_salmon — Mon, 17 Oct 2016 10:29:06 GMT

Hi,

I need to create a table with Grouped dimension of Year,Quarter, Month, Date. And i have a field called DAY (Mon, Tue etc).

I need to show DAY field as dimension along with above group.

When user select Date from Cyclic Group, then DAY dimension in Straight table should be displayed. Can anyone help what kind of condition we can write in Calculation dimension of DAY field?

Unfortunately i cannot able to share the data

Thanks.

Re: Show/Hide a field based on selection

sunny_talwar — Mon, 17 Oct 2016 10:32:06 GMT

Instead of calculated dimension, try using conditional hide/show for your dimension Day. The condition should be like this:

GetCurrentField([Group Name]) = 'Date'

Re: Show/Hide a field based on selection

raju_salmon — Mon, 17 Oct 2016 11:05:20 GMT

Hi Sunny,

Thanks for response, i have tried it with Day field, but it is not working, since at group name it is showing error.

GetCurrentField(<Grp_Date) = 'Date'

Re: Show/Hide a field based on selection

sunny_talwar — Mon, 17 Oct 2016 11:08:18 GMT

Not sure what is < sign used for? Is that part of your group name?

Re: Show/Hide a field based on selection

raju_salmon — Mon, 17 Oct 2016 11:10:22 GMT

Yes Sunny, followed as General practice for cyclic group. I have removed and tried.. it is working. Thanks alot.

Re: Show/Hide a field based on selection

sunny_talwar — Mon, 17 Oct 2016 11:17:05 GMT

Did your own response help you out? I would suggest not marking your own response as correct if it was not truly a correct response as it won't be helpful for others in the future

Re: Show/Hide a field based on selection

raju_salmon — Mon, 17 Oct 2016 13:41:55 GMT

Hi Sunny,

Sorry, just observer i made wrong selection as correct answer... thank for your comment to make it correct.