Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
mohitd910
Creator II
Creator 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
MK_QSL
MVP
MVP

SUM(

  {1<

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

       Flag={'Visit TYPE REVENUE'}

  >}

SELFPAYER_LC - DISCOUNT + PAYER1_LC)

View solution in original post

11 Replies
Anonymous
Not applicable

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
Luminary Alumni
Luminary Alumni

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
Luminary Alumni
Luminary Alumni

If you want to exclude all selections then try below expression

Sum({1} MeasureName)


Hope this helps you.


Regards,

Jagan.

mohitd910
Creator II
Creator II
Author

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
Creator II
Creator II
Author

NOt working bro

shraddha_g
Partner - Master III
Partner - Master III

can you provide sample app?

mohitd910
Creator II
Creator II
Author

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

jagan
Luminary Alumni
Luminary Alumni

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
MVP
MVP

SUM(

  {1<

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

       Flag={'Visit TYPE REVENUE'}

  >}

SELFPAYER_LC - DISCOUNT + PAYER1_LC)