topic Row count based on selections in QlikView

Row count based on selections

Anonymous — Wed, 09 Dec 2015 13:12:17 GMT

I have a straight table with about 17 000 records. I have created a textboox with a Count(Distinct(TradeName)) which counts the number of distinct TradeNames in the straight table as is illustrated below:

The distinct count of TradeName gives a value of 3801 as illustrated above. I would want this value to change based on various selections with various dimension values for example filter by date which should reduce the number 3801.

How can this be accomplished in QV?

Re: Row count based on selections

Anonymous — Wed, 09 Dec 2015 13:15:42 GMT

It should work automatically with this expression: Count(Distinct(TradeName))

You no need to do anything..

If your selected Dimension is associated with TradeName...It will change as per your selection

Re: Row count based on selections

sunny_talwar — Wed, 09 Dec 2015 13:16:34 GMT

I think it should already change if this -> Count(DISTINCT TradeName) is what you are using. It is not filtering based on selections?

Re: Row count based on selections

Anonymous — Wed, 09 Dec 2015 13:30:05 GMT

Many thanks, it is not changing based on any selections.

Re: Row count based on selections

Anonymous — Wed, 09 Dec 2015 13:30:39 GMT

Hi Sunny

There are no changes based on any selections.

Re: Row count based on selections

roger_stone — Wed, 09 Dec 2015 13:33:32 GMT

Is the table 'Detached'?

Re: Row count based on selections

Anonymous — Wed, 09 Dec 2015 13:42:47 GMT

HI Roger, thanks, it is not detached.

My data model is as below:

Re: Row count based on selections

Anonymous — Wed, 09 Dec 2015 13:42:57 GMT

Sample Data?

Re: Row count based on selections

roger_stone — Wed, 09 Dec 2015 13:49:01 GMT

Shouldn't you be counting [FDA Trade Name] ?

Re: Row count based on selections

Anonymous — Wed, 09 Dec 2015 13:51:55 GMT

I cannot see field TradeName in your Data Model.

Should it be Count ( Distinct ( [FDA TradeName] ) ) ?

Or maybe I am missing something.

Re: Row count based on selections

Anonymous — Wed, 09 Dec 2015 13:54:12 GMT

Agree with Bill, it should be: Count ( Distinct ( [FDA TradeName] ) )

Re: Row count based on selections

Anonymous — Wed, 09 Dec 2015 14:02:53 GMT

You are right Roger, i have another model within the same application with TradeName and so i had picked up the wrong field for that model.

Once again thank you all.

Re: Row count based on selections

Anonymous — Wed, 09 Dec 2015 14:03:36 GMT

Thank you are right as pointed to Roger

Re: Row count based on selections

Anonymous — Wed, 09 Dec 2015 14:04:05 GMT

Thanks Balraj most appreciated