topic Re: Alternate state issue in QlikView

Alternate state issue

manoranjan_d — Tue, 01 Aug 2017 07:40:18 GMT

Hi all,

In my UI i have two filters and one straight table

These two filters are defined with state

Filter 1 (field name : primary compare date ) as state 1

and filter 2 (field name : secondary compare date ) as state 2

in the straight all the expression as defined with the two state

example

exp1:

=Only({[state1]}amount)

exp2:

=Only({[state2]}amount)

so the user can make week wise compare

Now third filter needs to be added

example : description field as filter3

suppose if the user select the filter 3(description filed) the data in the straight table wont change as per the filter3 selection bcoz we have declared the exp as state1 and state2, now how to show the straight table data with selection of filter1,filter2 and filter 3 and to make compare the data

let me know any other way to achieve this

attached is the sample file

Re: Alternate state issue

devarasu07 — Tue, 01 Aug 2017 07:52:53 GMT

Hi,

Do you want to ignore description field value selection from the report? if so you simply exclude description field using below set expression.

=Only({<[state1],description=>}amount)

=Only({<[state2],description=>}amount)

Tks,Deva

Re: Alternate state issue

manoranjan_d — Tue, 01 Aug 2017 07:56:14 GMT

No,

i want to include the description field as list box in the UI and according to that the straight table have to show the records and also week wise compare have to be performed as per the primary compare date and secondary compare date filters .

Re: Alternate state issue

devarasu07 — Tue, 01 Aug 2017 07:57:54 GMT

Can you try like below,

Is possible to use alternate States with set analysis

Re: Alternate state issue

manoranjan_d — Tue, 01 Aug 2017 07:58:28 GMT

I have attached the file can u provide me the solution for this?

Re: Alternate state issue

manoranjan_d — Tue, 01 Aug 2017 08:01:38 GMT

there is proper solution of your link

Re: Alternate state issue

sunny_talwar — Tue, 01 Aug 2017 11:25:23 GMT

Try this

=Only({[state1]<description = $::description>}amount)

=Only({[state2]<description = $::description>}amount)