Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bijay_jha
Creator
Creator

Get the field name of expression in Dimension

Hi every one , Good Morning !

Today I need help in finding the field name of the expression. I created a

1) Bar Chart with

2) Dimension :  a) Region

                       b) =if(Month1=2,'Feb',If(Month1=3,'Mar',if(Month1=4,'Apr',if(Month1=5,'May','Jun'))))     [ Label = Month ]

both the dimension is grouped together and named as Group1.

3) Expression : Sum(Sales)

To get the result : I used =if(GetCurrentField([Group1])='Region','A',if(GetCurrentField([Group1])='Month1','B','C'))

but i did the result B .

30 Replies
bijay_jha
Creator
Creator
Author

Hi Sunny,

It does not make any effects, both works in same way.

I tried in both the way with single and double but give same result in both case.Issue.png

bijay_jha
Creator
Creator
Author

Not.jpg

Anil_Babu_Samineni

I think you need Concat with Chr(39) because if you select 2 months at a time how this condition proves true?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
bijay_jha
Creator
Creator
Author

Thanks, Anil

Sorry, I could not catch you, Can you please share the expression?

Anil_Babu_Samineni

I just gone to sunny reply, Can you try this?

If(GetCurrentField([Group1]) = '=if(Month=2,''Feb'',If(Month=3,''Mar'',if(Month=4,''Apr'',''May'')))', 'A', 'C')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
bijay_jha
Creator
Creator
Author

Yes Anil,

I tried even this...

Anil_Babu_Samineni

Will you provide latest sample? and result you want to see in object?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
bijay_jha
Creator
Creator
Author

Please have a look on the snapshot, I shared above.

I have given both the way I tried.

Anil_Babu_Samineni

Do you change single quotes from double quote in your expression? Looks like sunny's suggesting make sense. I am not sure where you made wrong.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
bijay_jha
Creator
Creator
Author

Hi have shared the data even,

Please have a try on this, might be due to some chilly mistake, I am not getting the output.