topic Re: Data Loading` in QlikView

Data Loading`

Wed, 25 Nov 2020 16:16:04 GMT

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‌

Re: Data Loading`

Chanty4u — Thu, 10 Mar 2016 06:55:19 GMT

u can use alternate state?

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

Re: Data Loading`

Chanty4u — Thu, 10 Mar 2016 06:56:03 GMT

for ur reference chk below

Alternate State Sample for Beginners

Re: Data Loading`

Anonymous — Thu, 10 Mar 2016 07:04:37 GMT

Two Options?

1) In table expression use set analysis like this?

=sum({<Class=>} SalesInput)

2) Use Alternate State

Re: Data Loading`

Thu, 10 Mar 2016 07:07:55 GMT

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

Re: Data Loading`

its_anandrjs — Thu, 10 Mar 2016 07:09:28 GMT

Use SET analysis here like

In any straight table

Dim:- States

Dim:- class

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

Regards

Anand

Re: Data Loading`

Chanty4u — Thu, 10 Mar 2016 07:10:10 GMT

chk dis

Ignore all selections except some specific fields using Set Analysis

Re: Data Loading`

jagan — Thu, 10 Mar 2016 07:10:31 GMT

HI,

Try like this

Chart: Straight Table

Dimension: States, Class

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

Class= will ignore the selection in that field.

Regards,

jagan.

Re: Data Loading`

Anonymous — Thu, 10 Mar 2016 07:12:22 GMT

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

=sum({<Class=>} SalesInput)

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

Re: Data Loading`

engishfaque — Thu, 10 Mar 2016 07:18:00 GMT

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

Re: Data Loading`

ogster1974 — Mon, 14 Mar 2016 14:40:47 GMT

I think the guys have already covered what I would have suggested in previous posts.

Regards

Andy