Fixed Dimension values in the report

[prachisangewar]

Hi,

I want to make a report which has a fixed template e.g. I have dimension as Category and another is Reporting Attributes

Every category has its own Attributes which should be should irrespective of whether the Fact has the data for them or not.

Also some Attributes exist for more than 1 Category.If I select the "Show All Values" I am able to see all Attributes but then on selecting any other filter like Transaction Date or Country from the List box only the relevant Attributes having data are shown.

I want the template to be fixed,If there is no data the measure should be a blank or zero.

Report 1 for Category 1

Attributes   Att Detail   Amount

A1              d1              10

A2               d2              -

A3               d3               5

A4                d4              2

Category 2    Att Detail         Amount

A3                     d3a              7

A4                     d4a              9

A5                     d5                20

A6                      d6               25

Please help to suggest.

Thanks a lot!

[SreeniJD]

Hi Prachi,

Hope you would be having fair idea of Qlikview Associativity, and it has pros and cons as well.

We have a option "Alternate State" which will certainly help you to get the desired results.

Let me know if you need more details.

Happy to help

Sreeni

[PrashantSangle]

Hi,

Go to Property -> General -> select Detached.

Regards

[prachisangewar]

Hi Sreeni and Max,

Thanks for the reply. But both the solutions don't work for my requirement.

I think I need to be more clear on the requirement.

I want the Selections from the list box or calender object to affect my report measures values but all dimensions should still be displayed.

Eg Report 1 User selected Country = SG

A1              d1              8

A2               d2              -

A3               d3               3

A4                d4              -

Report 1 User selected Country = US

A1              d1              -

A2               d2              20

A3               d3               7

A4                d4              15

The tables shown are the expected results,

But for me now If I select US as the Country the First row is not seen in the report at all and for SG the row 2 and 4 are not seen;but i want all attributes to be seen in the table.The "Show All" and uncheck of the "Suppress Null/Missing" does not work for my case as I am using calculated dimension.

Thanks

[vikasmahajan]

can you make 2 template one for US and other for SG if  dimensions are less considered for reporting

Vikas

[avinashelite]

In Order to achieve this you need generate the missing fact in the script , can you please provide the sample data so that we can help you out the same

[prachisangewar]

Hi Vikas,

There are many combination of such filter  which the users want .so cannot make different templates

[vikasmahajan]

Then provide some sample as per Avinash requested..

Vikas

[SreeniJD]

Hi Prachi,

I got the solution for you..

please be noted it is not very direct, you have to add a new fact column with the set analysis expression and then hide that fact column from the table.

Let me explain in detail..

you have two dimensions dim1,dim2

and one fact lets say sum(sales)

create a new fact lets say.. hidden fact = sum({1}sales) and hide this column..

That's it!

Hope this will helps!

Please close the thread and make it helpful or correct as per the result.

Sreeni

[prachisangewar]

Thanks Sreeni thi olution works for me