topic Re: Fixed Dimension values in the report in QlikView

Fixed Dimension values in the report

prachisangewar — Wed, 23 Sep 2015 09:17:42 GMT

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!

Re: Fixed Dimension values in the report

SreeniJD — Wed, 23 Sep 2015 09:22:35 GMT

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

Re: Fixed Dimension values in the report

PrashantSangle — Wed, 23 Sep 2015 09:32:08 GMT

Hi,

Go to Property -> General -> select Detached.

Regards

Re: Fixed Dimension values in the report

prachisangewar — Wed, 23 Sep 2015 09:46:14 GMT

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

Re: Fixed Dimension values in the report

vikasmahajan — Wed, 23 Sep 2015 10:12:05 GMT

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

Vikas

Re: Fixed Dimension values in the report

avinashelite — Wed, 23 Sep 2015 10:24:40 GMT

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

Re: Fixed Dimension values in the report

prachisangewar — Wed, 23 Sep 2015 10:36:20 GMT

Hi Vikas,

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

Re: Fixed Dimension values in the report

vikasmahajan — Wed, 23 Sep 2015 10:38:05 GMT

Then provide some sample as per Avinash requested..

Vikas

Re: Fixed Dimension values in the report

SreeniJD — Thu, 24 Sep 2015 05:51:43 GMT

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

Re: Fixed Dimension values in the report

prachisangewar — Fri, 25 Sep 2015 06:59:54 GMT

Thanks Sreeni thi olution works for me

Re: Fixed Dimension values in the report

Digvijay_Singh — Fri, 25 Sep 2015 07:04:25 GMT

Similar explanation here as well -

Show all values in Pivot/Straight Table (irrespective of current selection)

Re: Fixed Dimension values in the report

prachisangewar — Fri, 25 Sep 2015 08:34:51 GMT

Hi Sreeni,

The solution does not work when the calculated dimension has ablsoultely no data for the selected filter.

Eg IF I select Filter value F1

Report1 for Category 1

Attributes Att Detail Amount

A1 d1 2

A2 d2 -

A3 d3 1

A4 d4 2

but for Filter value F2

Attributes Att Detail Amount

completely blank.How can I fix this.Even if "Category 1" does not have data for any Filter value F2,

It should show the structure

Attributes Att Detail Amount

A1 - -

A2 - -

A3 - -

A4 - -

Please sugget if any ideas.

Thanks a lot!