Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

asb02512
New Contributor III

How to use Measure as Dimension in Qlik Sense

Hello Every one

i have data for aging analysis app

Untitled.png


The requirement is to change the measures 1-30days 31-60 days 61 - 90 days as dimensions as filter pane ,. when user select the 1-30 days ..... from the list in filter, the data of that particular selection should display under measures. is therey any one help me in this regard


Thank you

4 Replies
arvind_patil
Valued Contributor II

Re: How to use Measure as Dimension in Qlik Sense

HI Abu,

You need to create aging bucket like 1-30days,31-60days in script level . so you can use it as a list box.

Thanks,

Arvind Patil

abnormal
New Contributor

Re: How to use Measure as Dimension in Qlik Sense

Hi,

If the ageing buckets are calculated at the time of creating the visualization how can this be achieved?

We have user input as a cut off date and based on the difference between the cut off date and the due date of payment we find out the age of each invoice.

How can we represent this in a pie chart such that each section of pie would show the amount against each bucket?

Thanks,

Saikat

JustinDallas
Valued Contributor

Re: How to use Measure as Dimension in Qlik Sense

They wouldn't be created at the time of visualization, they would have to be created as part of the datamodel.

javier_garcia_g
New Contributor III

Re: How to use Measure as Dimension in Qlik Sense

Hello!

How I would create a ageing bucket?

I have similar problem. I have two measures, but I want they could be selected in a filter pane, to can show only one sometimes. And now always show the both in the table.


Thanks and regards.