Condition enabling of expression

[#1]

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

[sunny_talwar]

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

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

[Anonymous]

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!

[maxgro]

try to use the substringcount

example  conditional expression for B expression

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

[#5]

Hi Sunny,

PFA of screenshot.

Thanks,

MV

[sunny_talwar]

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

[kavita25 · Accepted solution]

Hi,

Check the qvw.

Regards,

Kavita

[settu_periasamy]

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

[qlikviewwizard]

Hi Check the attached application tab- Reports.

Hope this will help you.