topic Re: Condition enabling of expression in QlikView

Condition enabling of expression

Tue, 11 Aug 2015 07:19:25 GMT

Hi All,

I have pivot table which contains 5 expressions. here A,E will not respond to Record selections.

If i click on B table should display A,E,B expressions and If i click on B,C then A,B,C,E should show in the table.

I have tried many ways but didn't get solution.If i click on single record like B or C or D it's working but when i select B and C then it's not working.

I have attached sample QVW. Could you please take a look into this.

Thanks,

M V

Re: Condition enabling of expression

sunny_talwar — Tue, 11 Aug 2015 07:27:28 GMT

Not sure what your qvw looks like because I am using PE version of QlikView, but may be this:

{<Field += {'A', 'E'}>}

Re: Condition enabling of expression

Anonymous — Tue, 11 Aug 2015 07:28:19 GMT

in the epxression condition you check for single character but when two Records are selected you get e.g.B,C

so use

substringcount(GetFieldSelections(Record,','),'C')>0

replace C for your other expressions!

Re: Condition enabling of expression

maxgro — Tue, 11 Aug 2015 07:29:13 GMT

try to use the substringcount

example conditional expression for B expression

GetSelectedCount(Record)=0 or SubStringCount(Concat(Record, '|'), 'B') // GetFieldSelections(Record,',')='B'

Re: Condition enabling of expression

Tue, 11 Aug 2015 07:30:27 GMT

Hi Sunny,

PFA of screenshot.

Thanks,

Re: Condition enabling of expression

sunny_talwar — Tue, 11 Aug 2015 07:33:20 GMT

Thanks chiranjeevi‌ for the screenshot. Are they 5 different expressions or just one expression??

Re: Condition enabling of expression

kavita25 — Tue, 11 Aug 2015 07:46:51 GMT

Hi,

Check the qvw.

Regards,

Kavita

Re: Condition enabling of expression

settu_periasamy — Tue, 11 Aug 2015 07:54:28 GMT

One More solution, may be you can just use the SubStringCount(Concat(Record),'B') in Enable Condition.

Re: Condition enabling of expression

qlikviewwizard — Tue, 11 Aug 2015 08:19:42 GMT

Hi Check the attached application tab- Reports.

Hope this will help you.