Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mohitd910
Contributor II

How to restrict selections for only single sheet in qlikSense

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

1 Solution

Accepted Solutions

Re: How to restrict selections for only single sheet in qlikSense

SUM(

  {1<

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

       Flag={'Visit TYPE REVENUE'}

  >}

SELFPAYER_LC - DISCOUNT + PAYER1_LC)

11 Replies
Employee
Employee

Re: How to restrict selections for only single sheet in qlikSense

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)

MVP
MVP

Re: How to restrict selections for only single sheet in qlikSense

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.

MVP
MVP

Re: How to restrict selections for only single sheet in qlikSense

If you want to exclude all selections then try below expression

Sum({1} MeasureName)


Hope this helps you.


Regards,

Jagan.

mohitd910
Contributor II

Re: How to restrict selections for only single sheet in qlikSense

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
Contributor II

Re: How to restrict selections for only single sheet in qlikSense

NOt working bro

shraddha_g
Honored Contributor III

Re: How to restrict selections for only single sheet in qlikSense

can you provide sample app?

mohitd910
Contributor II

Re: How to restrict selections for only single sheet in qlikSense

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

MVP
MVP

Re: How to restrict selections for only single sheet in qlikSense

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.

Re: How to restrict selections for only single sheet in qlikSense

SUM(

  {1<

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

       Flag={'Visit TYPE REVENUE'}

  >}

SELFPAYER_LC - DISCOUNT + PAYER1_LC)