Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

manigunta
Contributor

how to compare two calculated dimensions

HI

how can we use Master item (dimension) in calcuating another master item as comparing if one master item value is greater . than another master item value then 1 else 0

can we use as above

22 Replies
sadasiva
Contributor

Re: how to compare two calculated dimensions

Hi,

We can't directly use master item in other expressions. Maybe we need to use full calculated dimension in other expression as well.

beck_bakytbek
Valued Contributor III

Re: how to compare two calculated dimensions

Hi Nagamani,

you can use the set expression to compare two calculated dimensions, but give more information or screenshot of your expected output

Beck

manigunta
Contributor

Re: how to compare two calculated dimensions

HI

i have created one dimension as 'createdate' where i changed date format  and also created another dimension as 'Completed date'

Now how can i use these two dimension columns

i need to do calculate cretaedate-completeddate

beck_bakytbek
Valued Contributor III

Re: how to compare two calculated dimensions

Can you give your example qliksense-file?

manigunta
Contributor

Re: how to compare two calculated dimensions

examle of qliksense file means

beck_bakytbek
Valued Contributor III

Re: how to compare two calculated dimensions

yes

beck_bakytbek
Valued Contributor III

Re: how to compare two calculated dimensions

Hi Nagamani,

or check this post: Using Alternate State in QLikSense (without Extensions)

maybe it suits to your issue

Beck

agigliotti
Honored Contributor II

Re: how to compare two calculated dimensions

please provide the .QVF file.

are you using Qlik Sense Desktop or Qlik Sense Enterprise ?

d_prashanthredd
Contributor III

Re: how to compare two calculated dimensions

Hi Nagamani,

You can create variables and compare or else straight away, use the calculated dimension (expressions) for comparing purpose.

Ex: I have two variables varMaxDate = 7/26/2017 and varMinDate = 3/1/2017.

I used these two variables in an expression to compare i.e. if($(varMaxDate) > $(varMinDate), 'Max', 'Min')

-Prashanth

Community Browser