Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

loveqliksense
New Contributor III

calculated dimension

Hi all,

I have a variable vchange which is a percentage calculation and I want to use it as dimension.

how can I do it?

Thanks

5 Replies
luismadriz
Valued Contributor

Re: calculated dimension

Hi,

Usually something like this:

=AGGR(calculation of the percentage,otherdimension)

The field other dimension is what you want differentiates each row

For example, if I need count of patient per hospital as a dimension I'd go:

=AGGR(Count(Patient),Hospital)

If I have 3 hospitals, there will be three rows and each row with the count

I hope this helps,

Luis

loveqliksense
New Contributor III

Re: calculated dimension

so if I have count of locations as measure and I want to use this vchange as dimension in bar chart, and I have other 3 different measures as well then,how can I do it?

luismadriz
Valued Contributor

Re: calculated dimension

I have to say that it's strange to have all those many as dimensions in the same chart but it could be done using similar procedure... maybe you want to explain what you have and the expected outcome?

loveqliksense
New Contributor III

Re: calculated dimension

I need to calculate a percentage value,vChange will give me the percentage value . I have 6 different measures Countt of X, Count of Y,sum (of X+Y),count of A, Count of C and Count Of D.

I do not have specific dimension I want to use this percentage value as alternate dimension in my bar chart.

luismadriz
Valued Contributor

Re: calculated dimension

Hi,

Then you just need all those as measures and you may just create a fake dimension such as ='Total'

I hope this helps,

Luis

Community Browser