Issue with Drill Up - Expression in Drill down dimension

[Sudeep]

Hi, I am facing problem in 'drill up' behavior (QlikSense development in Hub verison: Jun2017). When i use If-else expression in 'Drill down' dimension. The drill up is not working fine. Eg: Assume, Drill down dimension expression is like below If(condition,Dim1,Dim2) if i drill down, when chart is showing Dim2 and drip up, it shows Dim1 values (instead of Dim2) every time. Can anybody help me on this issue. What could be the possible solution? Thanks, Sudeep

[lironbaram]

hi 

can you post sample data , it's not clear exactly what is the problem 

[Sudeep]

Hi,

I have created the sample QVF for the scenario, i have explained. Please review the attached QVF.

What i have done in this QVF is as below. There is a drill down on CountryID->State in below chart. Also, there is flag filter.

If user selects flag as 'ID' ->CountryID will be displayed in  chart X-axis

if user selcts flag as 'Name->CountryName will be displayed in Chart X-axis.

So the X-axis is a drilldown Dimension (CountryID/Name->State). The above logic is created as expression in Drill down dimension(refer below screenshot).

The scenario where is the problem is: When user selects flag->Name. The 'Country name' displays in chart. When he drill down 'State name' displays. But when he drill up 'Country ID' displays instead of 'Country Name'. It should drill up to 'Country Name' only, when it is drill down from 'Country Name'. So, this is the issue. Please help him, how to achieve this, anybody. 

greatly appreciate community help on this.

Drill Down to State

Drill Down dimension

[Sudeep]

Sorry, I am not able to upload the QVF file here  it throuws error 'The contents of the attachment doesn't mathc its file type', everywhere issues 'huh'.

Any way, i am pasting the SCript of the QVF here. Please help

StateCountry:
Load * Inline [
StateID, StateName, CountryID,CountryName
kar, Karnatak, Ind, India
mah, Maharashtra, Ind, India
mi, Michigan, US, America
az, Arizona, US, America
man, manchester, UK, Britan
];

Fact:
Load * inline [
Product, Revenue, StateID
1, 100, kar
2, 200, kar
3, 300, mah
4, 500, mah
5, 600, mi
6, 700, mi
7, 800, az
8, 1200, az
9, 300, man
10, 400, man
];

flag:
Load * Inline [
flag
ID,
Name
];

[lironbaram]

hi 

in Qlik sense November 2018 

you can define field to be one selected value , 

and then use this in the calculated dimension 

=$(='Country'& flag)

[Sudeep]

Cannot Set 'default to be one selected value', as i am using Qliksense Hub verison: Jun2017.

Is there any other alternatives!? 

[Sudeep]

Hi, 

Anybody has any different work around, please post it here. 

Appreciate community help on this.

[Sudeep]

Hi,

Anybody has any different work around, please post it here.

Appreciate community help on this.