how to compare two calculated dimensions

[Anonymous]

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

[Anonymous]

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]

Hi Nagamani,

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

Beck

[Anonymous]

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]

Can you give your example qliksense-file?

[Anonymous]

examle of qliksense file means

[beck_bakytbek]

yes

[beck_bakytbek]

Hi Nagamani,

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

maybe it suits to your issue

Beck

[agigliotti]

please provide the .QVF file.

are you using Qlik Sense Desktop or Qlik Sense Enterprise ?

[d_prashanthredd]

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