topic Re: Get possible field issue in QlikView

Get possible field issue

mayankraoka — Tue, 09 Aug 2016 14:49:36 GMT

Hi All,

I am having issue to get possible fielid value.

In my scenario,I have sales metric which is visible only when my customer is XYZ. So that I am checking in if condition for all the possible values XYZ is associated then only we get the value.

I am aware of function getpossiblecount but it gives only count there is no function like get-possiblevalue for that field .

Can anyone tell me the way I can check the condition?

Regards,

Mayank

Re: Get possible field issue

Anonymous — Tue, 09 Aug 2016 14:54:58 GMT

Are you looking for Possible selection with set analysis !!!?

Sum({<customer = P({$} XYZ )>} sales)

Re: Get possible field issue

mayankraoka — Tue, 09 Aug 2016 14:57:59 GMT

Sorry for the confusion.

In this case this will filter only for XYZ data.I need that data which has at-least XYZ as customer.

Re: Get possible field issue

sunny_talwar — Tue, 09 Aug 2016 14:58:25 GMT

Get possible value can be replicated using Concat() function, but you will need to clarify what exactly are you trying to get

Re: Get possible field issue

mayankraoka — Tue, 09 Aug 2016 15:11:36 GMT

Hi Sunny,

Can you tell me How it can be done.

Attached app for your reference.Consider the case for Market metrics.I want to show this if associated CM (Filed) have possible value more than 2 along with HOF(Value)

Regards,

Mayank !

Re: Get possible field issue

sunny_talwar — Tue, 09 Aug 2016 15:15:15 GMT

I am not sure what you are looking to get. Can you elaborate on the required output?

Re: Get possible field issue

mayankraoka — Tue, 09 Aug 2016 17:55:07 GMT

Let me explain you the scenario.

In this use case ,I have confidentiality rule.In which I can show sales value only if it is associated to more than 1 enterprises,otl_cnt should be more than 3 and CM should be more than 2(But HOF should always be there)

by below expression I am able to achieve all the 3 conditions except how I will check that selections are having possible value of CM=HOF?

if(Count(DISTINCT CM)>2 and Count(DISTINCT ENTERPRISE)>1 and max(OTLT_CNT)>2,Sum( {<CM=>}sales),'NA'))

Let me know if you need any futher information .

Regards,

Mayank

Re: Get possible field issue

mayankraoka — Tue, 09 Aug 2016 18:38:23 GMT

Can anyone help me on this?

Re: Get possible field issue

sunny_talwar — Tue, 09 Aug 2016 18:41:25 GMT

May be check like this:

SubStringCount(Concat(DISTINCT '|' & CM & '|', ','), 'HOF') = 1

Re: Get possible field issue

mayankraoka — Tue, 09 Aug 2016 18:48:34 GMT

I think I have found the answer to the question thank you all for your reply.

Regards,

Mayank

Re: Get possible field issue

sunny_talwar — Tue, 09 Aug 2016 18:50:00 GMT

When HOF is in selection

When HOF is not in selection

Expression used is

SubStringCount(Concat(DISTINCT '|' & CM & '|', ','), 'HOF')

So when HOF is within the selection bucket, you will see 1, else you will see 0.

Alternatively, you can also try playing with this:

=Count(DISTINCT {<CM *= {'HOF'}>} CM)

Re: Get possible field issue

akshayjain90 — Wed, 10 Aug 2016 06:21:34 GMT

Hi Mayank,

Please try the below expression -

=if(sum({$<CT=p({<CM={'HOF'}>}CT)>}sales)>0,1,0)

Regards,

Akshay