Discussion Board for collaboration related to Creating Analytics for QlikView.
I have dimension like Mod_1, mod_2, mod_3 and new_1, new_2, new_3.
Now i want to use 'case statement' so that my result wil b mod_1, mod_2, mod_3 = 'Mod' and same as with 'New'.
please suggest how to use case statemnt in dimesion. I need this on urgent basis.
Go to Solution.
try this as a calculated dimension:
But perhaps you should fix this in the load script by adding a mapping table and using applymap to create a new field ModNew. The use the new field instead of the original dimension.
mapping load * inline [
load *, applymap('MapDim', FieldWithModAndNew) as ModNew
from ... etc
Clik on calculated dimention tab and write the desired Case Statement for your requirement.
And if you eloborate your Case functionality than i can help you ..
In the X-axis, i want MOD and NEW instead of mod_1, mod_2
i want mod_1 and mod_2 comes under MOD by using the case statement.
How its possible?
Sorry i didnt get u ...Why dont u just give a sample
thanks for the reply.
I will try this and get back to u.
I just want to know, how to rename the expression??
In my tooltip the whole expression is visible.. i want to rename this
how to do?
Just go to label on expression tab and do it
Done with that!!!