topic Re: Issue with Drill Up - Expression in Drill down dimension in App Development

Issue with Drill Up - Expression in Drill down dimension

Sudeep — Sat, 16 Nov 2024 07:06:59 GMT

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

Re: Issue with Drill Up - Expression in Drill down dimension

lironbaram — Thu, 06 Dec 2018 08:13:58 GMT

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

Re: Issue with Drill Up - Expression in Drill down dimension

Sudeep — Thu, 20 Dec 2018 09:53:49 GMT

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

Re: Issue with Drill Up - Expression in Drill down dimension

Sudeep — Thu, 20 Dec 2018 10:00:19 GMT

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
];

Re: Issue with Drill Up - Expression in Drill down dimension

lironbaram — Thu, 20 Dec 2018 13:30:52 GMT

in Qlik sense November 2018

you can define field to be one selected value ,

and then use this in the calculated dimension

=$(='Country'& flag)

Re: Issue with Drill Up - Expression in Drill down dimension

Sudeep — Wed, 26 Dec 2018 03:37:12 GMT

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

Is there any other alternatives!?

Re: Issue with Drill Up - Expression in Drill down dimension

Sudeep — Thu, 10 Jan 2019 05:54:06 GMT

Hi,

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

Appreciate community help on this.

Re: Issue with Drill Up - Expression in Drill down dimension

Sudeep — Thu, 10 Jan 2019 10:43:38 GMT

Hi,

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

Appreciate community help on this.