topic Re: Hide and show data based on list box selection in QlikView

Hide and show data based on list box selection

Fri, 24 Jan 2014 13:21:38 GMT

Hi All,

I have a req. like below

E.g. list box 'TYPE' which contains the values like 'permanent' and 'contract'

If am selecting 'permanent'

The values in pivot should like this;

EMPLOYEE(DIM) expression

emi-id

salary

salary account

If am selecting 'contract'

The values in pivot should like this;

EMPLOYEE(DIM) expression

emi-id

salary

salary account

Contract -period

vendor name

vendor location

Thanks in adv,

Ravi

Re: Hide and show data based on list box selection

Fri, 24 Jan 2014 13:25:55 GMT

you may use "active condition" in dimension tab according to only(value)='contact'

best regards

Chris

Re: Hide and show data based on list box selection

MK_QSL — Fri, 24 Jan 2014 13:33:41 GMT

You can use calculated dimension

=IF(GetFieldSelections(Type) = 'Contract', [vendor location])

and below in Enable Condition

GetFieldSelections(Type) = 'Contract'

This will give you Vendor Location if you select Contract in Type.

If you select Permanent in Type the Vendor Location will be dissappeared

Re: Hide and show data based on list box selection

Fri, 24 Jan 2014 13:40:45 GMT

Thanks for your immediate replies.But no luck !!!

I have to show more than one field data based on selection.

As mentioned in reply

IF(GetFieldSelections(Type) = 'Contract', [vendor location])

then only vendor location is coming.

e.g. if i select one value in list box ('Contract') it has to show 5 rows in a column and if i select (permanet) it has to show 8 rows.

In both some of them are common and we have to show extra rows when we select the relavent vale in listbox(permanet).

Thanks,

Ravi

Re: Hide and show data based on list box selection

MK_QSL — Fri, 24 Jan 2014 13:43:23 GMT

This should work else you are doing some mistake.

Can you upload you sample apps.

Re: Hide and show data based on list box selection

Fri, 24 Jan 2014 13:48:36 GMT

Could plz share the file if you have any already Manish.

Re: Hide and show data based on list box selection

Fri, 24 Jan 2014 16:18:31 GMT

Need help from some one. If in case any one faced same logic share the app.

Many thanks,

Ravi

Re: Re: Hide and show data based on list box selection

Fri, 24 Jan 2014 16:43:23 GMT

Hello Raviteja,

Please check out the attached file. As long as the relationship between Type and Employee exist in the way you described then its straight forward.

Let me know if there is something else to it that I might be missing.

Thanks

Re: Hide and show data based on list box selection

Fri, 24 Jan 2014 17:30:12 GMT

Thanks AJ...It seems to be match with my logic.Let me go in detail.I will revert if any i req.

Thanks for your time.