topic Re: SubStringCount Advanced in QlikView

SubStringCount Advanced

brunopaulo — Wed, 25 Nov 2020 16:16:04 GMT

Hi community,

I can't solve this problem and would be great if you could help me.

At the moment i have 4 tables each one has Dim1, Dim2, Metric1.
The values on this fields change based on Dim3. If dim3 has no selection, then show nothing. If Dim3 has 1 selected i want to show the results for that selection, if 2 values of dim3 are selected then show me the correct values. And the perfection is if dim3 has 2 value selected i could represent all in metric1 column.

Any help would be great. Thank you in advance

Best Regards

Bruno Paulo

Re: SubStringCount Advanced

MarcoWedel — Tue, 29 May 2018 22:35:25 GMT

please post some sample data and your expected result

Re: SubStringCount Advanced

Anil_Babu_Samineni — Wed, 30 May 2018 02:48:21 GMT

This is my assumption?

If(GetSelectedCount(Dim3)=0, '',

If(GetSelectedCount(Dim3)=1, Sum(Metric1),

If(GetSelectedCount(Dim3)>2, Sum({<Dim3=P(Dim3)>} Metric1),

If(GetSelectedCount(Dim3)=2, Sum({<Dim3=>} Metric1)))))