Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rickhuang666
Contributor
Contributor

Count Greyed Out Selections

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?

Untitled.png

1 Solution

Accepted Solutions
sunny_talwar

May be this

Count(TOTAL DISTINCT {<STORE>} week)

View solution in original post

4 Replies
sunny_talwar

May be this

Count(TOTAL DISTINCT {<STORE>} week)

rickhuang666
Contributor
Contributor
Author

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

sunny_talwar

STORE is used to ignore selection in the Store field

tajmohamed30
Creator III
Creator III

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