topic Re: Straight table in QlikView

Straight table

gokulnath2592 — Wed, 25 Feb 2015 10:00:11 GMT

Hi community,

how to set straight table as static and not associated with any field.

thanks,

Gokul

MK_QSL — Wed, 25 Feb 2015 10:01:05 GMT

Use Alternate State !

Wed, 25 Feb 2015 10:06:41 GMT

Probably the easiest way but detach can also be used or set analysis (showing the full set) for the expression in the chart.

mukesh24 — Wed, 25 Feb 2015 10:16:26 GMT

Hi,

As suggested Manish, Simply change Alternate state of straight Table

MK_QSL — Wed, 25 Feb 2015 10:16:51 GMT

Detach will be automatically disabled on document reload... Probably Set Analysis can be also a good idea.

Anonymous — Wed, 25 Feb 2015 10:23:31 GMT

Hi Gokulnath,

Use below logic in exp's, filters will not be applied on straight table:

sum([$<Date= ,DIM1=,DIM2=,DIM3=}>} Amount)

Regards

Neetha

oknotsen — Wed, 25 Feb 2015 10:25:10 GMT

Change your expressions and add "ALL" or {1}.

Example:

Change

sum(Sales)

into

sum(ALL Sales)

sum({1} Sales)

gokulnath2592 — Wed, 25 Feb 2015 10:56:48 GMT

thanks guys for all your help.

Regards,

Gokul

MK_QSL — Wed, 25 Feb 2015 11:08:15 GMT

Please close the thread by selecting appropriate answer.