Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Loading`

Hi Every One ,

My Question is If i was selected the class A the corresponding data will shown in the left side of the table ..that is not my requirement . if i selected class A or B any values i don't want to change Ogster1974

00.png

10 Replies
Chanty4u
MVP
MVP

u can use alternate state?

or  can u explain with some more details along with  ur sample qvw?

Chanty4u
MVP
MVP

for ur reference chk below

Alternate State Sample for Beginners

Anonymous
Not applicable
Author

Two Options?

1) In table expression use set analysis like this?

=sum({<Class=>} SalesInput)

2) Use Alternate State

Not applicable
Author

can u explain briefly.....i am thinking to Set Analysis

its_anandrjs

Use SET analysis here like

In any straight table

Dim:- States

Dim:- class

Expr:- Sum({<class=>} SalesInput)

Regards

Anand

jagan
Luminary Alumni
Luminary Alumni

HI,

Try like this

Chart: Straight Table

Dimension: States, Class

Expression: Sum({<Class=>}SalesInput)

Class= will ignore the selection in that field.


Regards,

jagan.

Anonymous
Not applicable
Author

Simply use above set expression in your table....

=sum({<Class=>} SalesInput)


Here Class is your field name & SalesInput is a measure in table

engishfaque
Specialist III
Specialist III

Dear Sai,

Please note, if you would like to ignore any dimension/field value then just write down your Set Analysis Modifier with equal sign (=), such as given below

Expression:

Sum({<class=>} Sales)

Example: Ignore more than two dimensions/field values

Sum({<states=, class=>} Sales)

Kind regards,

Ishfaque Ahmed