How to restrict selections for only single sheet in qlikSense

[mohitd910]

Dear Friends,

How to restrict selections for only single sheet in qlikSense‌

jagan‌

stalwar1‌

mrkachhiaimp‌

or for a set analysis

this is my measure:-

No  filter should work on this

SUM({$<Date_Date={'>=$(=YearStart(Max(Date_Date)))<=$(=YearEnd(Max(Date_Date)))'},Flag={'Visit TYPE REVENUE'}>} SELFPAYER_LC - DISCOUNT + PAYER1_LC)

Regards,

Mohit Dahiya

Message was edited by: Mohit Dahiya

[Anonymous]

I am not sure exactly you question or issue. However if you want to ensure that no filters are applied on top of you Set Analysis then start from the data universe of 1.

I.e.

SUM({1<Date_Date={'>=$(=YearStart(Max(Date_Date)))<=$(=YearEnd(Max(Date_Date)))'},Flag={'Visit TYPE REVENUE'}>} SELFPAYER_LC - DISCOUNT + PAYER1_LC)

[jagan]

Hi Mohit,

I heard that there is an alternate state extension, you can google and use it.

Or you can use Sum({<FieldName1=,FieldName2=>} MeasureName) to exclude the selections in all the objects in a sheet where you want to exclude the selectins.

Regards,

Jagan.

[jagan]

If you want to exclude all selections then try below expression

Sum({1} MeasureName)

Hope this helps you.

Regards,

Jagan.

[mohitd910]

Not Working. bro when i am selecting any date then it is changing. i want a bar chart on the basis of this measure that will not reflect or changes when any selection will be there in any filter.

[mohitd910]

NOt working bro

[shraddha_g]

can you provide sample app?

[mohitd910]

bro its client data. i can show you through team viewer or skype.

[jagan]

Hi Mohit,

It should work.  Wherever you want selections to be considered give

Sum(Sales)

Wherever you don't want selections to consider give

Sum({1} Sales)   // Ignores all selections

Sum({<Field1=, Field2>} Sales)    // Ignores Field1 and Field2 selections

Based on ur requirements use above logics.

Regards,

Jagan.

[MK_QSL · Accepted solution]

SUM(

  {1<

       Date_Date={'>=$(=YearStart(Max({1}Date_Date)))<=$(=YearEnd(Max({1}Date_Date)))'},

       Flag={'Visit TYPE REVENUE'}

  >}

SELFPAYER_LC - DISCOUNT + PAYER1_LC)