Discussion board where members can get started with Qlik Sense.
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
We can't directly use master item in other expressions. Maybe we need to use full calculated dimension in other expression as well.
you can use the set expression to compare two calculated dimensions, but give more information or screenshot of your expected output
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
Can you give your example qliksense-file?
examle of qliksense file means
or check this post: Using Alternate State in QLikSense (without Extensions)
maybe it suits to your issue
please provide the .QVF file.
are you using Qlik Sense Desktop or Qlik Sense Enterprise ?
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')