topic Re: conditional Enable and Disable of expression in QlikView

conditional Enable and Disable of expression

Tue, 16 Sep 2014 10:09:17 GMT

Hi All,

I have requirement as follows.

in my application i m using a straight table with expressions. These expressions are the calculations for allowances for employees. So i am having a list box with all the allowances Name.

Now the requirement is.

when user select an allowance from the list box ,then only the particular expression should gt enabled or show ,all others should be hidden. at a time user can select more than 1 expression also. so accordingly it should display..

How can i achieve the same?please suggest..

Thanks..

Re: conditional Enable and Disable of expression

MK_QSL — Tue, 16 Sep 2014 10:14:07 GMT

Go to Expression Tab

Select Your Expression

Tick Conditional

Write Below as a conditional expression

=GetSelectedCount([allowances Name])>0

Re: conditional Enable and Disable of expression

jagan — Tue, 16 Sep 2014 10:14:18 GMT

Hi,

Check this link

Adhoc reporting in Qlikview

Hope it helps you.

Regards,

Jagan.

Re: conditional Enable and Disable of expression

avinashelite — Tue, 16 Sep 2014 10:16:54 GMT

Hi Reena,

How many allowance type you have??

Re: conditional Enable and Disable of expression

deepakqlikview_123 — Tue, 16 Sep 2014 10:18:28 GMT

In short you need to work on Ad Hoc report.

Ad-Hoc Reporting in Qlikview | Qlik Community

How to do ad hoc reporting in qlikview 11?

Thanks

Re: conditional Enable and Disable of expression

Anonymous — Tue, 16 Sep 2014 10:21:58 GMT

Hi,

you should pass the allowance in the dimension then in the expression check enable the conditional

then put = getselectedcount(allowance)>0 .

That is the one way or you can make Adhoc report as jagan marked.

Thanks

Re: conditional Enable and Disable of expression

jagan — Tue, 16 Sep 2014 10:26:24 GMT

Hi,

Use this expression as conditional expression

Regards,

Jagan.

Re: conditional Enable and Disable of expression

Tue, 16 Sep 2014 10:27:19 GMT

Hi..

Thanks for your reply..

But i have more than 160 allowances as expressions,each with different rules. so for each allowance selection i need to enable and disable.

Re: conditional Enable and Disable of expression

Tue, 16 Sep 2014 10:35:33 GMT

Hi Reena,

in the conditional of each expression give conditional like this..

if(match ( only ({1} [Allowance]), $ (= cancat (distinct chr(39) & [Allowance] & chr(39) , ' , ' ) ) ) , 1, 0 )

Regards,

Vivek

Re: conditional Enable and Disable of expression

Tue, 16 Sep 2014 10:51:37 GMT

Hii...

Thanks Jagan... its working..

bt while using this condition without any selection it will show all the expressions i think.

In my case if there is no selection then dimensions it should display and there is one expression without condition that also it should display. Rest all expressions it should be hidden.

Thanks..

Re: conditional Enable and Disable of expression

jagan — Wed, 17 Sep 2014 01:17:21 GMT

Hi Reena,

Then use this expression

=If(GetSelectedCount(Allowance) > 0, SubStringCount('|' & Concat(distinct Allowance, '|') & '|', '|Allowance1|'))

Hope this helps you.

Regards,

Jagan.