Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
dynamic_girl
Creator
Creator

Requirement

i have two alternate states defined in my sheet,state 1 and state2

state1 in chart shud show the selected dimension (whatever is from filter)

and state 2 expressions shud show everything excluding the state1 expressions,

so say:

count({state1 * $}id)

how shud the state 2 expressions wud be written?

4 Replies
dynamic_girl
Creator
Creator
Author

can anyone please help for the above query

Gysbert_Wassenaar

try this: count( { 1 - (state1*$) } id )


talk is cheap, supply exceeds demand
dynamic_girl
Creator
Creator
Author

so if there are no selections made its just showing me state 1 bar,

what will be the state 2 den?

Gysbert_Wassenaar

empty


talk is cheap, supply exceeds demand