topic Re: Problem faced while creating Report in QlikView

Problem faced while creating Report

Anonymous — Sat, 05 Apr 2014 13:11:35 GMT

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

Re: Problem faced while creating Report

its_anandrjs — Sat, 05 Apr 2014 13:54:42 GMT

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

Re: Problem faced while creating Report

nizamsha — Sat, 05 Apr 2014 14:51:36 GMT

u can nullify the dimension which should not affect ur report

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

Re: Problem faced while creating Report

PrashantSangle — Sat, 05 Apr 2014 14:56:51 GMT

Hi,

Try with

1> nullifying fields

2>select Detached option box from general field.

Regards,

Re: Problem faced while creating Report

Sun, 06 Apr 2014 17:18:31 GMT

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