topic Re: Case 922 When i select Expression = E-Mail_List , How to make Table 2 Total display 4 ? in QlikView

Case 922 When i select Expression = E-Mail_List , How to make Table 2 Total display 4 ?

paulyeo11 — Fri, 11 Sep 2020 12:02:10 GMT

Hi All

When i select Expression = E-Mail_List .

How to make Table 2 Total display 4 ? Now it display wrong value.

Enclosed my QVW

Re: Case 922 When i select Expression = E-Mail_List , How to make Table 2 Total display 4 ?

Kushal_Chawda — Fri, 11 Sep 2020 12:08:20 GMT

@paulyeo11 change expression to below for table 2

count(distinct $(ColumnDim51))

Re: Case 922 When i select Expression = E-Mail_List , How to make Table 2 Total display 4 ?

paulyeo11 — Fri, 11 Sep 2020 12:18:05 GMT

Hi Sir

Thank you for sharing .

I need to make it dynamic . If user change the selection of Expression from Email to Sales . The table 2 also will change the value on expression.

Re: Case 922 When i select Expression = E-Mail_List , How to make Table 2 Total display 4 ?

Kushal_Chawda — Fri, 11 Sep 2020 12:25:28 GMT

@paulyeo11 try below

=pick(Match([Pls select 51st Dim],'E-Mail_List','SALES'),
count(DISTINCT $(ColumnDim51)),sum($(ColumnDim51)))

Re: Case 922 When i select Expression = E-Mail_List , How to make Table 2 Total display 4 ?

paulyeo11 — Fri, 11 Sep 2020 12:30:05 GMT

Thank a lot.