Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
geetaalhan
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
its_anandrjs

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
its_anandrjs

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

nizamsha
Specialist II
Specialist II

u can nullify the dimension which should not affect ur report

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

PrashantSangle

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