Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator
Creator

Expression Help for Third Options.

Hi,

Thanks for reply. But here in the script:

Options1:
Load * Inline [
Options1
Millions
Full value];

Options2:
Load * Inline [
Options2
Yes
No];

Options3:
Load * Inline [
Options3
‘1M$’
‘2M$’
‘3M$’];

Expression :--> if(GetFieldSelections(Options1)='Millions',sum({<account={'EX'},Date={'$(=vTime1)'}>}a_expenses)/1000000, sum({<account={'EX'},Date={'$(=vTime1)'}>}a_expenses))),

if(GetFieldSelections(Options1)='Millions', if(GetFieldSelections(Options2)='No', sum({<account={'EX'},Date={'$(=vTime1)'}>}non_pti)/1000000, sum({<account={'EX'},Date={'$(=vTime1)'}>}non _pti_cc)/1000000)

Now I have to use options3 where user can select 1M$, so > 1M$ records should to select, If User Select 2M$ then >2M$ records should to select or if 3M$ then >3M$ records.

So Can anyone help me on this.

Lots of advance thanks.

Regards,

AK

Labels (1)
0 Replies