Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

RE:Technical suggestion?

Hi all,

one scenario,

This is in Qliksense

Is there any way that we can create the filter quickly?

Thanks in advance.

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Create an excel file with the values of the field and load that in Qliksense like below

Transaction:

LOAD

*

FROM Transactions;

LEFT JOIN(Transaction)

LOAD

DimensionName,

1 AS SelectValues

FROM DataSource;

Now select 1 in SelectValues filter and bookmark it.  Now whenever there is a change in list box values we can just update the excel file.

Hope this helps you.

Regards,

jagan.

View solution in original post

2 Replies
reddy-s
Master II
Master II

Hi Chanty,

Save the filter as a bookmark and duplicate the app. This way you will be able to replicate the issue in production to dev. Try the same with stagging as well.

You can even export the application and re-import it into an other environment using QMC.

Thanks,

Sangram.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Create an excel file with the values of the field and load that in Qliksense like below

Transaction:

LOAD

*

FROM Transactions;

LEFT JOIN(Transaction)

LOAD

DimensionName,

1 AS SelectValues

FROM DataSource;

Now select 1 in SelectValues filter and bookmark it.  Now whenever there is a change in list box values we can just update the excel file.

Hope this helps you.

Regards,

jagan.