Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

balu_1991
New Contributor

Issue

Hi All,

I got a requirement like as need t dimension value grouping.

Dimension is like as Region North, east, south, west and same in  region dimension.

and need value as shown based grouping .

How can i resolve the issue?

6 Replies
luismadriz
Valued Contributor

Re: Pivot Table problem

Hi Balu,

What do you mean by "fix"? that won't change is selections are made?

If so you just need to reset the possible selections for example

Sum({<Dimension1=, Dimension2= ... etc. >} GrossSales)

So when someone make any selection of Dimension1, 2, etc. Sum(GrossSales) won't change,

I hope this helps,

Luis

MVP
MVP

Re: Pivot Table problem

What do you want to resolve? Are you asking for (1) help with transforming that data in the load or (2) displaying in the front end. If (1), you need to explain and possibly supplysamples of your source data. If (2), then you need to describe in detail your data structure and supply a sample QVW/QVF containing some representative data.

In either case, you need to explain the calculations you want to take place.

balu_1991
New Contributor

Re: Pivot Table problem

Hi Jonathan,

But as per security reason i can't display and provide qvw and source data.

here my problem want to displaying in front end .

Gross sales and net sales are expressions. But those are need to display as horizontal basis showing in above pic.

luismadriz
Valued Contributor

Re: Pivot Table problem

Hi Zaid and community,

I've been trying this in Qlik Sense without much progress.

I'm using these as measures:

if(dimensionality()=0,Sum(GrossSales)) for Gross Sales

Sum(SalesCost) for Sales Cost >>> Sorry Zaid, I had to call it something like this to make sense in my head

if(dimensionality()=0,Sum(GrossSales)-Sum(SalesCost)) for Net Sales

But haven't been able to remove the nulls yet. This is as far as I've made it in Qlik Sense...

Untitled.png

This is the data I loaded

    

RegionCategoryMonthSalesGrossSalesSalesCost
EastA01/01/20172500500
NorthA01/01/20172500200
SouthC01/01/20172500600
WestB01/01/20172500100
EastA01/02/201725002000
NorthA01/02/20172500300
SouthC01/02/20172500200
WestB01/02/20172500500
EastA01/03/20172500500
NorthA01/03/20172500800
SouthC01/03/20172500500
WestB01/03/20172500600
EastA01/04/20172500600
NorthA01/04/20172500700
SouthC01/04/20172500300
WestB01/04/20172500400
EastA01/05/20172500200
NorthA01/05/20172500600
SouthC01/05/20172500900
WestB01/05/20172500800
balu_1991
New Contributor

Re: Pivot Table problem

Is it possible to remove Nulls?

luismadriz
Valued Contributor

Re: Pivot Table problem

Hi Balu,

I tried but they are still showing, please note here:

Untitled.png

Community Browser