Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

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
Master
Master

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
Not applicable
Author

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
Master
Master

Can you give your example qliksense-file?

Anonymous
Not applicable
Author

examle of qliksense file means

beck_bakytbek
Master
Master

yes

beck_bakytbek
Master
Master

Hi Nagamani,

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

maybe it suits to your issue

Beck

agigliotti
Partner - Champion
Partner - Champion

please provide the .QVF file.

are you using Qlik Sense Desktop or Qlik Sense Enterprise ?

d_prashanthredd
Creator III
Creator III

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