topic Re: Conditional count of field in text object based on expression held in variable. in QlikView

Conditional count of field in text object based on expression held in variable.

Anonymous — Sun, 03 Sep 2017 15:56:21 GMT

Hi,

I have a text object (# of IRs) that I want to display the distinct count of CHANGE_ID based on an expression where the CHANGE_ID's TOTAL SCORE is <= 7. The expression works in a Pivot Chart but when I put the expression into a variable (v_total_score) and bake that into the text object, it only counts when you drill to one CHANGE_ID.

The below image shows what I'm trying to do.

Re: Conditional count of field in text object based on expression held in variable.

Anil_Babu_Samineni — Sun, 03 Sep 2017 16:41:04 GMT

May be this?

Count({<CHANGE_ID = {"=sum(TOTAL CHANGE_ID)<=7"} >} distinct CHANGE_ID)

Re: Conditional count of field in text object based on expression held in variable.

Anonymous — Sun, 03 Sep 2017 17:10:20 GMT

Hi Anil,

When I use Count({<CHANGE_ID = {"=sum(v_total_score)<=7"} >} distinct CHANGE_ID) it counts all CHANGE_ID's and doesn't filter out those where the TOTAL SCORE is <= 7.

I'm wondering if I need to use Aggr() in here somewhere?

Thoughts?

Thanks,

Jason

Re: Conditional count of field in text object based on expression held in variable.

Anil_Babu_Samineni — Sun, 03 Sep 2017 17:16:36 GMT

I don't think you need any aggregation over expression. Can you show where and how you are declare the variable

Re: Conditional count of field in text object based on expression held in variable.

Anonymous — Sun, 03 Sep 2017 17:22:24 GMT

See below. Something to consider, the v_total_score variable works in a text object when a single CHANGE_ID is selected but shows '-' when more than one is selected.

Re: Conditional count of field in text object based on expression held in variable.

vinieme12 — Sun, 03 Sep 2017 19:01:49 GMT

Try

=Sum ( TOTAL AGGR( YOUREXPRESSION , CHANGE_ID ) )

Re: Conditional count of field in text object based on expression held in variable.

Anil_Babu_Samineni — Mon, 04 Sep 2017 02:05:57 GMT

Please attach file to test

Re: Conditional count of field in text object based on expression held in variable.

Anonymous — Mon, 04 Sep 2017 14:45:34 GMT

Hi Anil, did you attach it?

Re: Conditional count of field in text object based on expression held in variable.

Anil_Babu_Samineni — Mon, 04 Sep 2017 14:47:07 GMT

No, I am asking please attach some sample application to test

Re: Conditional count of field in text object based on expression held in variable.

Anonymous — Mon, 04 Sep 2017 15:08:11 GMT

Here you go.