topic Re: Nice Simple How to! I think in QlikView

Nice Simple How to! I think

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

Much simplified version of the issue, we have data that looks like this:

ID represented people and Att_Id represents visits. We have a variable, say 4, we want to display the ID and Att_Id where the total number of visits is equal to the variable. So in the example it would show ID 234567 and the associated Att_ids

Cheers Andy

Re: Nice Simple How to! I think

tamilarasu — Thu, 27 Oct 2016 08:25:37 GMT

Hello Andrew,

Maybe the below one,

Dimensions:

Att_ID

Expression:

If(Count(Total <ID> ID)=$(YourVariableName),1)

Re: Nice Simple How to! I think

awhitfield — Thu, 27 Oct 2016 08:33:25 GMT

Almost,

getting

Re: Nice Simple How to! I think

tresB — Thu, 27 Oct 2016 08:34:33 GMT

May be like attached sample.

Re: Nice Simple How to! I think

tamilarasu — Thu, 27 Oct 2016 08:38:54 GMT

I have attached a sample. How the variable defined? Is it expression or just a number.?

Re: Nice Simple How to! I think

Anil_Babu_Samineni — Thu, 27 Oct 2016 08:43:46 GMT

What does the variable you have declared over there?

Re: Nice Simple How to! I think

sunny_talwar — Thu, 27 Oct 2016 09:16:10 GMT

I think you should be able to use set analysis also

Dimension

ID,

ATT_ID

Expression

Only({<ID = {"=Count(DISTINCT ATT_ID) = vVar"}>} 1)

Avg({<ID = {"=Count(DISTINCT ATT_ID) = $(vVisit)"}>} 1)

Tested this on Tamil's sample and seems to work the same way as the if statement

Re: Nice Simple How to! I think

awhitfield — Thu, 27 Oct 2016 09:29:50 GMT

Star turn!

Sorted!

Cheers Andy