Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using a Qlikview Straight Table applying a calculated dimension filter below and then suppressing rows when value is null in the dimensions tab. (2nd image below))
=if(if(SS='x'and PrePrioity ='ST' and i1_4>1 and (Location='ED' or Location='ED Hold' ) and Code<>'4066000' and Code<>'423656170' and Code<>'422533328' and Code<>'554865740' and Code<>'554878353' and not TstName LIKE 'U*',1,0)=1,Sequence)
I have calculated the Max values for columns Step 1 – Step 3 & Duration on the 1st row. I now want to access the Max Value in Step 1 (Image below) to use in a new formula but am unable to determine the formula QlikView used to derive the value of 2 below. Can you help Me obtain the formula?
Message was edited by: Richard Ouellette I cannot share the app but did attach a mock up Presidents.qvs with the max [Served From] field.
Message was edited by: Richard Ouellette PresidentsII.qvw added 1/31
This:
=Max({<Party = {'Democrat'}, President = {"=Len(President) > 15"}>}Aggr([Served From], President, Party))
I think what ever your id statement is doing should be easy to replicate in set analysis
Max(/SetAnalysis\ Aggr(/Expression\, /Dimensions\))
Set Analysis
{<SS = {'x'}, PrePrioity = {'ST'}, i1_4 = {'>1'}, Location = {'ED', 'ED Hold'}, Code -= {4066000, 423656170, 422533328, 554865740, 554878353}, TstName -= {'U*'}>}
Expression and dimensions should already be available to you..
HTH
Best,
Sunny
Would you be able to share your application for us to see what you have?
In the example you have used, the if statement is relatively simple, so this should work for you. But original app have a complex if statement.... but you get the idea
=Max({<[Served From] = {'19*'}>}Aggr([Served From], President, Party))
Sunny
This was very helpful and I am still trying to get my arms around it and as a result uploaded another example where the selection criteria is limited to the dimension fields only and not the expression fields I am trying to calculate the Max. Few observations:
=if(if(SS='x'and PrePrioity ='ST' and i1_4>1 and (Location='ED' or Location='ED Hold' ) and Code<>'4066000' and Code<>'423656170' and Code<>'422533328' and Code<>'554865740' and Code<>'554878353' and not TstName LIKE 'U*',1,0)=1,Sequence)
Hopefully this helps clarify my need a bit more. Feedback welcome. Below is an image from the uploaded PresidentsII.qvs
Rick
This:
=Max({<Party = {'Democrat'}, President = {"=Len(President) > 15"}>}Aggr([Served From], President, Party))
I think what ever your id statement is doing should be easy to replicate in set analysis
Max(/SetAnalysis\ Aggr(/Expression\, /Dimensions\))
Set Analysis
{<SS = {'x'}, PrePrioity = {'ST'}, i1_4 = {'>1'}, Location = {'ED', 'ED Hold'}, Code -= {4066000, 423656170, 422533328, 554865740, 554878353}, TstName -= {'U*'}>}
Expression and dimensions should already be available to you..
HTH
Best,
Sunny
Sunny
Thank you for you valuable help!
Best
Rick
Not a problem. I am glad I was able to help.
Best,
Sunny