Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression with several distict selections

Hi!

I am new to qlikview and trying to learn how to make extresssions.

I am trying to combine to different extression bu I do not know how:

My expressions is

if (GetSelectedCount([RäkÅr])<>1,
-
Sum({<[RäkÅr]={$(=max([RäkÅr])-1)} >} Belopp)/1000,
-
Sum({<[RäkÅr]={$(=RäkÅr-1)}>} Belopp)/1000)

and

 

=((sum({<[Rrnummer] = {4}>} Belopp))/1000)

What I am trying to do is that I want a pivottable that will give my only values from "Rrnummer=4) no matter and from a "Räkår" that is one  less than the present one.

If anyone could help me how to write this expression it would be helpful.

Thank you

Jonny

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be, like this?

if (GetSelectedCount([RäkÅr])<>1,
-
Sum({<[Rrnummer] = {4}, [RäkÅr]={$(=max([RäkÅr])-1)} >} Belopp)/1000,
-
Sum({<[Rrnummer] = {4}, [RäkÅr]={$(=RäkÅr-1)}>} Belopp)/1000)

View solution in original post

4 Replies
simenkg
Partner
Partner

Hi, Johnny.

In your first expression you only need the upper expression:


Sum({<[RäkÅr]={$(=max([RäkÅr])-1)} >} Belopp)/1000


This is because when a RäkÅr is selected that is the max([RäkÅr]).

I did not read your question properly the first time.

A combined expression would be

Sum({<[RäkÅr]={$(=max([RäkÅr])-1)},[Rrnummer] = {4} >} Belopp)/1000

Regards
SKG

tresesco
MVP
MVP

May be, like this?

if (GetSelectedCount([RäkÅr])<>1,
-
Sum({<[Rrnummer] = {4}, [RäkÅr]={$(=max([RäkÅr])-1)} >} Belopp)/1000,
-
Sum({<[Rrnummer] = {4}, [RäkÅr]={$(=RäkÅr-1)}>} Belopp)/1000)

View solution in original post

sujeetsingh
Master III
Master III

Johny ,

Please come up with simple words and use some day to day fields .

Not applicable
Author

Thank you tresesco, this works very well.

Jonny