topic Re: Count Greyed Out Selections in QlikView

Count Greyed Out Selections

Anonymous — Fri, 02 Jun 2017 15:50:39 GMT

Hello,

Please see the following graph. So the total sales actually incurred every week through W1 to W17, so in total there are 17 weeks. But for these particular items at these particular stores, the sales only incurred through W4 to W16, which is 13 weeks.

I'm using count(total distinct week) to get the # of WEEKS and it got 13, but the requirement was to get it as 17. How could I count W1, W2, W3 and W17 when they are greyed out?

Re: Count Greyed Out Selections

sunny_talwar — Fri, 02 Jun 2017 15:52:26 GMT

May be this

Count(TOTAL DISTINCT {<STORE>} week)

Re: Count Greyed Out Selections

Anonymous — Fri, 02 Jun 2017 16:03:22 GMT

What is the {Store} used for? Can you interpret this? Thanks

Re: Count Greyed Out Selections

sunny_talwar — Fri, 02 Jun 2017 16:04:09 GMT

STORE is used to ignore selection in the Store field

Re: Count Greyed Out Selections

tajmohamed30 — Sun, 04 Jun 2017 11:32:24 GMT

right clik on that sheet --->Go to trigger tab-->

add action on ActiveSheet-->click -->Add-->selection-->select in field

then put Filedname above and in search string write the values