topic Re: Table Box Filters and Expression HELP!!! in QlikView

Table Box Filters and Expression HELP!!!

RedDead — Wed, 16 Jan 2019 15:05:10 GMT

Hi,

I have a table box where i can have multiple ID's. The multiple ID's are recording where the ID priority has changed. How do i get my table box to show all entries where the ID has had its priority changed? See example for one ID that has had its Job priority changed.

Thanks

Re: Table Box Filters and Expression HELP!!!

m_woolf — Wed, 16 Jan 2019 15:31:18 GMT

Switch from table box to straight table. Then you can use an expression that shows IDs where count({1}JOB_PRIORITY)>1

Re: Table Box Filters and Expression HELP!!!

RedDead — Wed, 16 Jan 2019 15:42:40 GMT

Hi,

Thanks for your help. Ok, i have switched now to a straight table and added the three fields SK_JOBKEY, JOB_PRIORITY and SK_PRIORITY.

Then under the expressions tab added the expression count({1}JOB_PRIORITY)>1

This added an additional field to the table all with -1 value and all SK_JOBKEY entries still showing.

Any ideas where ive gone wrong

Thanks

Re: Table Box Filters and Expression HELP!!!

m_woolf — Wed, 16 Jan 2019 15:44:59 GMT

Maybe

aggr(count({1}JOB_PRIORITY),SK_JOBKEY)>1

Re: Table Box Filters and Expression HELP!!!

RedDead — Wed, 16 Jan 2019 15:48:34 GMT

Thanks,

No joy....tried this and it returns exactly the same -1 values just changes the field to aggr(count({1}JOB_PRIORITY),SK_JOBKEY)>1

Re: Table Box Filters and Expression HELP!!!

m_woolf — Wed, 16 Jan 2019 15:50:02 GMT

Can you attach a sample qvw or some sample data?

Re: Table Box Filters and Expression HELP!!!

m_woolf — Wed, 16 Jan 2019 16:19:02 GMT

I also couldn't make the expression work, so I added a counter field in load script:

Re: Table Box Filters and Expression HELP!!!

MarcoWedel — Wed, 16 Jan 2019 20:14:55 GMT

maybe you can try with:

Count(Distinct Total <SK_JOBKEY> JOB_PRIORITY) > 1

hope this helps

regards

Marco

Re: Table Box Filters and Expression HELP!!!

RedDead — Thu, 17 Jan 2019 08:27:01 GMT

Thanks for this that has now retrieved the data i would expect. Also out out curiosity why on the SK_JOBKEY_CNT field does it always show -1 and how could you hide this field just to leave the remaining 3 fields?

Many Thanks

Re: Table Box Filters and Expression HELP!!!

RedDead — Thu, 17 Jan 2019 08:28:11 GMT

Hi Marco,

This has also worked and returned data i was expecting. Again out out curiosity why on the SK_JOBKEY_CNT field does it always show -1 and how could you hide this field just to leave the remaining 3 fields?

Many Thanks

Re: Table Box Filters and Expression HELP!!!

m_woolf — Thu, 17 Jan 2019 12:50:55 GMT

Go to Chart Properties|Presentation and hide the field

Re: Table Box Filters and Expression HELP!!!

RedDead — Thu, 17 Jan 2019 14:40:54 GMT

Many Thanks for your help on this. I now have the following :-

ID PRIORITY

47 R1

47 R5

What i would like to do now is concatenate the two priorities to achieve this

ID PRIORITY

47 R1, R5

Ideally i would rather do this within the table and not the script if possible.

What would be your best suggestion on how i could do this?

Thanks

Re: Table Box Filters and Expression HELP!!!

MarcoWedel — Thu, 17 Jan 2019 22:21:48 GMT

Hi again,

this expression might work for you:

Concat({$<SK_JOBKEY={"=Count(Distinct JOB_PRIORITY)>1"}>} JOB_PRIORITY, ', ')

hope this helps

regards

Marco