Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Problem faced while creating Report

Hi,

Could anyone help ,How to get rid of current selection while creating report?

Data in the report changes according to the current selection

but I want  that current selection does not change the data that are  already there in the report.

Thanks

1 Solution

Accepted Solutions

Use SET analysis in your charts expression like

Eg:- If you have dimensions Year, Month, Region, Country

In Expression

Sum({< Year=, Month=, Region=, Country= >} Sales)

IF you use dimension with '=' SET analysis expression bypass the selection from the expression.Suggest use the current selection expression with equal sign in the expression then no effect in the chart.

Regards

View solution in original post

4 Replies

Use SET analysis in your charts expression like

Eg:- If you have dimensions Year, Month, Region, Country

In Expression

Sum({< Year=, Month=, Region=, Country= >} Sales)

IF you use dimension with '=' SET analysis expression bypass the selection from the expression.Suggest use the current selection expression with equal sign in the expression then no effect in the chart.

Regards

View solution in original post

Specialist II
Specialist II

u can nullify the dimension which should not affect ur report

sum({$<year=,month=,quater=,country=,region=,sales=>}Sales)

Hi,

Try with

1> nullifying  fields

2>select Detached option box from general field.

Regards,

PS

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable

Create a Bookmark, and define the report to print with that Bookmark selections. You can do it from the Report Settings --> Selections --> Bookmark